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