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.

---
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?

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


---
Regards,
Norman



"Norman Jones" wrote in message
...
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?

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

*** Sent via Developersdex http://www.developersdex.com ***

Data Text to columns

Tim

--
Tim Williams
Palo Alto, CA


"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?