Forum Discussion
MASS MERGING TWO COLUMNS FOR MORE THAN 500 ROWS AT ONE TIME
I have a spreadsheet in Excel with over 500 names that need to be merged first name last name, but it take too long to concatenate one row at a time and I wanted to know If it's possible to do full c...
You mean with a formula like:
=A2&" "&B2
=A2&" "&B2
Yes, but versus typing formula 500 times since its different cell #'s is there an easier way because I have 7 spread sheets of 500 names and that would mean typing formula about 3500 times.
- I'm afraid I miss your point. You can simply copy the formula down accross all cells next to your data, Excel adjusts the row numbers automatically.
I have tried to copy formula and I can't seem to get it, would you be so kind in telling me how to do it ?
- You click on the first cell with the correct formula and choose Copy from the Start tab (or hit control+c). Then you select the cells on which you want the new formula and press control+v or click Paste.
