How to Separate Names in Excel:
Split First and Last Name
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Microsoft Excel is often used to store data including personal information like names, addresses, contact numbers, etc.
There are times when the names in the data are full names and you would like to split them into first names and last names (sometimes with middle names).
However, users often complicate it by using different functions like ‘SEARCH’, ‘LEN’, ‘LEFT’, ‘RIGHT’, and others.
It’s actually simpler than you think! Let’s get started! 😊
*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.