Seperating Text in One Field into 2 Fields EG FullName

[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,

 

[Guest]

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.