Hi David,
If you don't already have your answer, such as if the data
is not actually separated by a space, you might also take a
look at

Sorting, Some notes on sorting in Excel
http://www.mvps.org/dmcritchie/excel/sorting.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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