I want to split for following text out which is contained in one cell

AXSHEFFIELD 10.00 0.29


I would like to split it into 3 cells, the first having the text and
the next 2 having the 2 amounts. All fields can be varied in length,
but have spaces between them

Thanks


--
katmando
------------------------------------------------------------------------
katmando's Profile: http://www.excelforum.com/member.php...o&userid=29803
View this thread: http://www.excelforum.com/showthread...hreadid=495126