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

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

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

May we see a sample of your data?

"pat" wrote:

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