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?