Anyone good with Excel?
Ok, I am merging data from two columns with the formula =A2&&B2 in column C.
Now that works for line 2, but how do I make the formula work for every single ascending line, without manually changing the formula each time e.g. =A3&B3 etc?
Posted By: Hertz van Rental, Oct 22, 14:02:53
Follow Ups
- double click on the bottom right corner of the cell with the formula in
Posted By: Ralf Scrampton, Oct 22, 14:06:45 - 4Use "concatenate"
Posted By: CB41, Oct 22, 14:06:45 - 8Put =A2&&B2 into cell C2, click on the cell
Posted By: Arizona Bay, Oct 22, 14:04:59
Reply to Message
Written & Designed By Ben Graves 1999-2025