Try this sequence of action on a spare copy of your sheet

Put in C1 (Biff's formula) : =--LEFT(B1,FIND(" ",B1)-1)
Put in D1: =TRIM(MID(B1,FIND(" ",B1)+1,99))

Select C1:D1, fill down until the last row of data in col B

Col C gives you the numeric parts, col D returns the text parts

Now just select cols C and D,
and do a copy paste special as values to overwrite cols A and B
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"David" wrote in message
...
Biff, Thankyou for your formula, the only thing is that it does NOT remove
the digits from the main cell (B1 etc), only copies them. So if I use a
LEFT or MID etc, then manually wipe out the digits left in the B column
then
the results collapse in the A column. I want if possible to once and for
all
remove digits(or text) in the main column and in this case leave A with
the
digits and B with only the selected text.
Any further help please??
Dave