Excel Tip: Combine Two Columns of First and Last Names


Combining Names

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.


Please login or register to join the discussion.

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

thanks a lot

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 alot.. it was really helpful. keep up the good work

Worked Great - THANKS

thanks a lot...

This worked perfectly! Thanks!

Very Helpful!! Thank you

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

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


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

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

very helpful!! thank you!


that so good thanks alot


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

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