Seperating Text in One Field into 2 Fields EG FullName
 

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,

Seperating Text in One Field into 2 Fields EG FullName
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SunRay" wrote:
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,