Video for Excel:
Video for Google Sheets:
In Excel:
Right click on the column to the right of the name column, and click Insert
2. Click on the Letter of the name column
3. Click on Data
4. Click on Text to Columns
5. Have Delimited selected, then click Next
6. Have Space set as your delimiter
7. Click Finish
In Google Sheets:
1. Right click on the name column's letter, and Insert 1 column right
2. Left click on the name column's letter so that it is highlighted
3. Click on Data, Split text to columns
4. Set the separator as a Space