Hi Randy,

Try:

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

This requires the next column cell to be blank.

---
Regards,
Norman



"Randy Patterson" wrote in message
m...
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?