Excel Tip: Combine Two Columns of First and Last Names

Combining Names
pixeldeluxe_iStock_Wedding
19

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:

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Share this content

Replies

Please login or register to join the discussion.

avatar
By Noble
Jun 26th 2015 01:11

thanks it was really helpful.....:p

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

thanks a lot

Thanks (0)
avatar
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)
avatar
By Kushal
Jun 26th 2015 01:11

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

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

Worked Great - THANKS

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

thanks a lot...

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

This worked perfectly! Thanks!

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

Very Helpful!! Thank you

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

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

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

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

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

AMAZING!!!! THANKS!

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

information was very helpful n I could do my task easily.

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

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

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

very helpful!! thank you!

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

Thanks!

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

that so good thanks alot

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

great.

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

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

Thanks (0)
avatar
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)