Excellent!

Thank you so much for your help.

George M.

--
"Gary''s Student" wrote in message
...
Hi George:

Quite easy. Our first formula looked for the first blank and display the
housenumber to the LEFT of the blank. This formula displays "the rest of
the
story":

=MID(A1,FIND(" ",A1)+1,9999)


Thus if A1 contains 123 North Maple Avenue
then
=LEFT(A1,FIND(" ",A1)-1) will display 123
=MID(A1,FIND(" ",A1)+1,9999) will display North Maple Avenue


then
--
Gary''s Student - gsnu200812


"George M. Fodor" wrote:

Thank you for your suggestion. This does and excellent job of displaying
the
house number.

What I'd really like to do, though, is wind up with the street name, so
that
I can sort on that value.

George M.

"Gary''s Student" wrote in
message
...
All your examples have a number followed by a blank followed by the
rest
of
the address:

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

--
Gary''s Student - gsnu200812