Click the Column Header that contains the names to be separated.

Click "Convert Text to Columns Wizard - Step 1 of 3"

Click to check "Space." You can also indicate if your names are separated by something other than a space.\
Click "Next &gt;"

Click "Convert Text to Columns Wizard - Step 2 of 3"

Click "Finish" to create first and last names in separate columns.

This guide provides step-by-step instructions on how to separate names in Excel into two columns. By following these steps, you can easily split names into first and last name columns, making it easier to organize and analyze your data.

How to Separate Names in Excel Into Two Columns