# Excel Tip: Combine Two Columns of First and Last Names

pixeldeluxe_iStock_Wedding
Tags

If you have a spreadsheet that contains a column of first names and a column of last names, and you would like to combine those names into one column, here's a quick trick that will get the job done.

For this example, let's assume that Column A contains first names and Column B contains last names. We will place the combined first and last names in Column C, with a space separating the first and last names.

Step 1: To combine two columns of names into one column, use this formula in the first row of column C:
=CONCATENATE(A1", ",B1)

Note that there should be a space separating the two quotation marks in the formula.

Step 2: Copy the formula down for as many names as you have. The first and last names will appear together in Column C, separated by a space.

If you no longer need the names in Columns A and B and want to remove those names, follow these steps:

Step 3: Highlight the combined names in Column C

Step 4: Click the Copy button

Step 5: While the cells are still highlighted, choose Edit, Paste Special from the menu, click the "Values" box, then click OK.

Step 6. Delete the contents of columns A and B.

You can also use this procedure to combine names in reverse order, with the last name first and a comma separating the last and first name. In this situation, the formula for Column C would include a comma between the quotation marks and would look like this:

=CONCATENATE(B1",",,A1)

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.

### Replies

By Noble
Jun 26th 2015 01:11

Thanks (0)
By pedro
Jun 26th 2015 01:11

thanks a lot

Thanks (0)
By Excelmerge
Jun 26th 2015 01:11

There is also an even easier solution which doesn't use formulas and allows you to combine cells together that are not text. http://www.anotherwaytodothis....

Thanks (0)
By Kushal
Jun 26th 2015 01:11

Thanks alot.. it was really helpful. keep up the good work

Thanks (0)
By imarefree
Jun 26th 2015 01:11

Worked Great - THANKS

Thanks (0)
By Juraid
Jun 26th 2015 01:11

thanks a lot...

Thanks (0)
By Amanda
Jun 26th 2015 01:11

This worked perfectly! Thanks!

Thanks (0)
By michelle
Jun 26th 2015 01:11

Thanks (0)
By Meg
Jun 26th 2015 01:11

This just saved me a ton of stress. Thanks so much. Incredibly helpful.

Thanks (0)
By janeburt
Jun 26th 2015 01:11

Amazing! Thanks SO MUCH! Last year, I had to do this MANUALLY! Ugggg!

Thanks (0)
By Cheng
Jun 26th 2015 01:11

AMAZING!!!! THANKS!

Thanks (0)
By Sharath
Jun 26th 2015 01:11

Thanks (0)
By Sharath
Jun 26th 2015 01:11

excel is one crazy thing I hav ever seen.... lov to learn more.... :)

Thanks (0)
By soumya
Jun 26th 2015 01:11

Thanks (0)
By Kevin
Jun 26th 2015 01:11

Thanks!

Thanks (0)
By Youssef Abuown
Jun 26th 2015 01:11

that so good thanks alot

Thanks (0)
By Sobuj Prantor
Jun 26th 2015 01:11

great.

Thanks (0)
By wentworthcheswell
Jun 26th 2015 01:12

Thank you....easy and it worked!!!!!!!

Thanks (0)
By Abhijeet
Jun 26th 2015 01:12

My Friend This is was really very helpful. Thank you so much.
This was just done in 1 mint.

Thanks (0)