software

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

AXSHEFFIELD 10.00 0.29I 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: www.excelforum.com/member.php...oamp;userid=29803
View this thread: www.excelforum.com/showthread...hreadid=495126Look at Datagt;Text To Columns with a space separator

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;katmandoquot; gt; wrote in
message ...
gt;
gt; I want to split for following text out which is contained in one cell
gt;
gt; AXSHEFFIELD 10.00 0.29
gt;
gt;
gt; I would like to split it into 3 cells, the first having the text and
gt; the next 2 having the 2 amounts. All fields can be varied in length,
gt; but have spaces between them
gt;
gt; Thanks
gt;
gt;
gt; --
gt; katmando
gt; ------------------------------------------------------------------------
gt; katmando's Profile:
www.excelforum.com/member.php...oamp;userid=29803
gt; View this thread: www.excelforum.com/showthread...hreadid=495126
gt;

Thanks

Nigel--
katmando
------------------------------------------------------------------------
katmando's Profile: www.excelforum.com/member.php...oamp;userid=29803
View this thread: www.excelforum.com/showthread...hreadid=495126