1
To begin, open your workbook in Excel.
2
Click the Column Header that contains the names to be separated.
3
Click "Data" from the top ribbon.
4
Click "Text to Columns"
5
Click "Delimited"\
Click "Next >"
6
Click to check "Space." You can also indicate if your names are separated by something other than a space.\
Click "Next >"
7
Click "Finish" to create first and last names in separate columns.
