How can I combine 2 columns into 1, Excel?
 

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

How can I combine 2 columns into 1, Excel?
 

Vandy1 wrote:
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
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

How can I combine 2 columns into 1, Excel?
 

It worked!!

Thank you for your help Alan, have a good day.

Josh

"Alan Beban" wrote:

Vandy1 wrote:
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
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