use data(menu)-text to columns

delimiter is <space

in the wizard in the thrid step denote destination as B2


"Shake" wrote in
message ...

Does anyone know if it is possible to Un-concatenate a cell.

If "John Smith" is in cell A2 can i put "John" in cell B2 and "Smith"
in cell C2.


--
Shake
------------------------------------------------------------------------
Shake's Profile:
http://www.excelforum.com/member.php...o&userid=28577
View this thread: http://www.excelforum.com/showthread...hreadid=482731