Excel: first name in one column, last name in another column. How do I get them in the same column?

I use this format b/c sorting thru long lists of names is easier. Now I want to print the names in one column with a space btwn first and last name.

Excel: first name in one column, last name in another column. How do I get them in the same column?
In Cell C1, insert "=A1 %26amp; " " %26amp; B1", assuming first name is in A and last name is in B.





Drag the fill handle of C1 to fill up the other cells.





Copy the Column C and right click. Select "Paste Special", select "Values" only. Now you can delete Columns A and B if you want to.
Reply:click on column and drag where you want them
Reply:If A1 had first name and B1 has last name, you can write





=A1%26amp;" "%26amp;B1





as formula in C1, for example.





Then, you can copy and paste to copy this formula for the entire column.
Reply:I go with arbitrage..





One more tip..





If you want to copy that entire First name and last name to other excel sheet, copy and use Paste Special and choose "Values" alone
Reply:Insert a "CONCATENATION" function in the 3rd column. FOr example, assume cell A3 and B3 have the first and last names. Put this formula in cell C3:





=CONCATENATE(A3," ",B3)





To cCopy the formula down do this:


- Select the first concatenated result in column C


- Hold down shift and click the LAST row in colunm C


- From the top menu select Edit-%26gt;Fill-%26gt;Down top copy the formula.





TaDa!