Maybe this:

A1 = 111 Maple Dr

B1 formula:

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

Then sort on column B.

--
Biff
Microsoft 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?