How do I sorty by addresses, ignoring number, using street name

P

pat

I am trying to sort an excel file by address, but using the street name as
the sort, not the number. ANy ideas
 

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
Alpha-sort addresses, ignoring first 1-3 numerals 5
Sorting characters, ignoring numbers 7
how to sort addresses in microsoft excel 2
Match Account ID from combining street names and numbers 1
Sorting 1
Sorting cells with a string formulas 1
Word Create a Phone Book using MailMerge in word 2007 0

Top