How can I combine 2 columns into 1, Excel?

V

Vandy1

I have an Excel spreadsheet with Last names in Column A and First names in
Column B. I am trying to combine the two columns into one (last name, first
name). The spreadsheet contains 4,184 rows, is there a way to convert the
entire spreadsheet? Thank you in advance for your help.

Josh
 
A

Alan Beban

Vandy1 said:
I have an Excel spreadsheet with Last names in Column A and First names in
Column B. I am trying to combine the two columns into one (last name, first
name). The spreadsheet contains 4,184 rows, is there a way to convert the
entire spreadsheet? Thank you in advance for your help.

Josh
Click to expand...
Assuming your names start on Row2, enter in Cell C2

=A2 & ", " & B2

Then grab the fill handle of Cell C2 (i.e., the little square in the
lower right corner of the cell) and double click.

Alan Beban
 
Top