Knowledgebase
Knowledgebase
How to divide first name and surnames in Excel
Posted by A Gasiorowski on 05 October 2016 09:42 AM

If you are given a CSV or Excel spreadsheet with first and surnames in the same column, there is a way to divide them into two separate columns.

  1. Highlight the column with the names in it
  2. Click on the data tab
  3. click text to columns
  4. Change options to delimited only
  5. Next
  6. Tick space only
  7. Next
  8. Finish

Your first and surnames should now be divided.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: