Skip to main content
All CollectionsFrequently Asked QuestionsSpreadsheet Help
How to Separate First and Last Name in your Spreadsheet
How to Separate First and Last Name in your Spreadsheet
Jake Cook avatar
Written by Jake Cook
Updated over 10 months ago

Video for Excel:

Video for Google Sheets:

In Excel:

  1. 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

Did this answer your question?