We cover how to split first and last names into multiple columns in excel. Sometimes you receive data where entries are squashed together in cells which makes analysing them more difficult. In our case, we have the names in column C and would like to sort the last names in alphabetical order however this isn’t possible as the first and last names are in the same cell. To overcome this, we can use the text to columns method, using a space as the delimiter.

Access the templates featured in The Excel Hub’s video tutorials here:
https://theexcelhub.myshopify.com/

Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation=1

Please share this video with others that may find it useful:
https://youtu.be/Y4sO8Nzs6YY

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:
[email protected]

Overview: (0:00)
Show Text To Columns Wizard: (0:36)
Select File Type: (0:53)
Delimiter Type: (1:19)
Text Formatting: (1:38)
Output: (1:47)

Please take the opportunity to connect and share this video with your friends and family if you find it useful.