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

--
Shak
-----------------------------------------------------------------------
Shake's Profile: http://www.excelforum.com/member.php...fo&userid=2857
View this thread: http://www.excelforum.com/showthread.php?threadid=48273