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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you alphabetize street addresses within a column? 1
Match Account ID from combining street names and numbers 1
Word Create a Phone Book using MailMerge in word 2007 0
Split data in field on character return 0
Sorting characters, ignoring numbers 7
Vlookup 1
how to sort addresses in microsoft excel 2
In search of a new Obelisk 6

Back
Top