Seperating Text in One Field into 2 Fields EG FullName

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that I have a list of Employees names. Unfortunately the
List has there full names and I want to seperat them into First Name and
Surname. the First Name Has a space after it before the surname starts.

EG
FullName
John Smith

I want to seperate these into
First Name Surname
John Smith

Any Help would be very appreciated,
 
One way is to use Data > Text to Columns

Select the col of names.
Click Data > Text to Columns, delimited.
Check "Space" in step 2, click Finish.
 
Back
Top