Combine first and last name cells into one

Modified on Fri, 23 Feb, 2018 at 1:30 PM

If you have a spreadsheet, where the first and last name are in two different cells, but need them into one for e.g. if importing your data into a website, some may only recognise a "Full name"


Make a column next to your First name and Last name, e.g. Full name


Type in the name into your first cell for Full name, then underneath this cell, start typing in the name for the second person, you will see Excel will recognise what you might be trying to achieve, when you see the other names appear, simply press Enter, and it will populate all the other names for you

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article