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
Feedback sent
We appreciate your effort and will try to fix the article