Spliting data

[blander]

Hi,

I need to split some data into two different cells: for example;

Name
Bob Thomas
John Smith
C Ward

into

FirstName LastName
Bob Thomas
John Smith
C Ward

They are all names...

Cheers

 

[Guest]

highlight the row
Data....text to columns.....delimited...choose space as the delimiter

This should do what you wish if there is a space between each first and last
name.

 

[blander]

cheers worked a treat!

 

[blander]

need your help again, really apreciate it

I have all the data seperated.. except some of them containe
salutations e.g.

Name
Mr Sam Fisher
Bob Smith
Mrs Carla O Toole

WHICH IS NOW

Name1
Mr
Bob
Mrs

Name2
Sam
Smith
Carla

Name3
Fisher
O

Name4
Toole

So all the colums are out of order

I have 40 000 records i need to sort

Any way to seperate each colum according to spaces within the initia
field??

Cheer

 

[blander]

need your help again, really apreciate it

I have all the data seperated.. except some of them containe
salutations e.g.

Name
Mr Sam Fisher
Bob Smith
Mrs Carla O Toole

WHICH IS NOW

Name1
Mr
Bob
Mrs

Name2
Sam
Smith
Carla

Name3
Fisher
O

Name4
Toole

So all the colums are out of order

I have 40 000 records i need to sort

Any way to seperate each colum according to spaces within the initia
field??

Cheer