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

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

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
>