Sorting street address

T

Tom S.

I would like to sort a column with street addresses by
street name. However, Excel sorts by the street number
first. How can I put the streets in order by street name
then street number?
 
B

Bob Phillips

Tom,

Split the number and names in separate helper columns, and sort on those
columns.

For instance, if A1 has the address, in B1, put

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

and in C1 put

=RIGHT(A1,LEN(A1)-LEN(B1)-1)

and sort on C and then B

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top