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

"David" wrote in message
...
I have a long column with numbers on the leftside of column then a space
then text. How do I remove the numbers to an adjacent column eg below

A1 B1
10 text xxxxx
111 textxxxx
112 textxxx etc
Would like:
A1 B1
10 textxxxxx
111 textxxxx
112 etc

regards Dave.