Try Daily Dose:
http://www.dicks-blog.com/archives/2...rmulas-part-1/
************
Anne Troy
www.OfficeArticles.com

"JG" wrote in message
...
little help, thanks


I have a column with street addresses, the street numbers are
separated by one space from the street name.
I would like to cut the numbers (1 to maybe a high of 1900) and paste
the street numbers to an adjoining column.

I'll have to start reading Excel books. any recommendations. thanks
again