cell splitting

[Randy Patterson]

I have one cell which contains the first and last name separated by a space.
I want to change this into two separate cells. The names are all different
lengths. I am unable to find any command to do this. Sort of a backwards
concatenate. Does anyone know how to do this?

 

[Norman Jones]

Hi Randy,

Try:

Data | Text to Columns | Delimited | Check the 'Space Option | Finish

This requires the next column cell to be blank.

 

[Norman Jones]

Hi Randy,

Data | Text to Columns | Delimited | Check the 'Space Option | Finish

should read:

Data | Text to Columns | Delimited | Next | Check the 'Space Option | Finish

 

[Tim Williams]

Data >> Text to columns

Tim

 

[Randy Patterson]

Thanks for the help. It was a lot easier than I thought.