Space delimited? Datatext to columnsdelimited next, space as delimiter and
finish
make sure that the column to the right is empty before doing this

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Roger" wrote in message
...
I have 2 words I each cell, I would to put the 2nd word in a new cell, how
am
I doing it?