cell splitting

  • Thread starter Thread starter Randy Patterson
  • Start date Start date
R

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?
 
Hi Randy,

Try:

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

This requires the next column cell to be blank.
 
Hi Randy,

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

should read:

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