MASS MERGING TWO COLUMNS FOR MORE THAN 500 ROWS AT ONE TIME

[rocio negrete]

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 columns at once with a formula, or is there an easier way?

[#2]

You mean with a formula like:
=A2&" "&B2

[#3]

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.

[#4]

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.

[#5]

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 ?

[#6]

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.