Spliting data

  • Thread starter Thread starter blander
  • Start date Start date
B

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
 
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.
 
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
 
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
 
Back
Top