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

Question

I have a spreadsheet in Excel with over 500 names that need to be merged first name last name,&nbsp;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?
&nbsp;

jkpieterse · Answer

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

rocio negrete · Answer

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.

jkpieterse · Answer

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.

rocio negrete · Answer

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 ?

jkpieterse · Answer

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.

Forum Discussion

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

Share

Resources