Thanks Bob, That did the trick. Just for my enlightenment, can you
explain why it [=MID(A1,FIND(" ",A1)+1,255) ] is writtrn in that
format and how it works?

On Tue, 16 Jun 2009 14:17:26 -0400, "Bob Umlas"
wrote:

helper column:
=MID(A1,FIND(" ",A1)+1,255)
fill down
sort on this column
Bob Umlas
Excel MVP

wrote in message
.. .
I have a database that lists addresses in the following format:
111 Maple Dr.

I want to split the street number from the Street name so that I can
sort on the street name only. Is this possible?