How can I combine 2 columns into 1, Excel?

[Guest]

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

 

[Alan Beban]

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

 

[Guest]

It worked!!

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

Josh