Function

K

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 an
the next 2 having the 2 amounts. All fields can be varied in length
but have spaces between them

Thank
 
B

Bob Phillips

Look at Data>Text To Columns with a space separator

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top