Sorting street address

  • Thread starter Thread starter Tom S.
  • Start date Start date
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?
 
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)
 
Back
Top