funtion please

J

JG

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
 
B

Bob Phillips

=LEFT(A2,FIND(" ",a2)-1)

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top