If you have a list of full names in one column and need to separate them into First Name and Last Name, Excel provides a few easy ways to do this.
Best for: When you want a quick and simple way to split names based on a space.
Steps:
Select the column that contains the full names (e.g. Column A).
Go to the Data tab in the top ribbon.
Click on Text to Columns.
In the wizard that appears, choose Delimited, then click Next.
Check the box for Space, then click Next.
Choose where you want the split data to appear (the default will overwrite the original column).
Click Finish.
➡️ The first and last names will now appear in two separate columns.