Function

[katmando]

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

[Bob Phillips]

Look at Data>Text To Columns with a space separator

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"katmando" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[katmando]

Thanks

Nigel