Hi!

Try this in A1 and copy down as needed:

=--LEFT(B1,FIND(" ",B1)-1)

Biff

"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.