How do I sort a list of addresses by street name (ignoring the ad.

[Guest]

How do I sort a list of residential addresses by street name (ignoring the
address number) that precedes the namei of the street)?

 

[Guest]

easiest way i guess would be to make a new column for just the street numbers
and then filter street name in ascending

 

[Joseph Meehan]

How do I sort a list of residential addresses by street name
(ignoring the address number) that precedes the namei of the street)?

I suspect this is going to be a complex issue. You not only are going
to need to address the number part of the address but other variations such
as

123 N Main St
123 North Main St
One Main St
123A North Main St
123 N. Main Street

Getting rid of the 123 can be done with just a little work. But I don't
think you would like the results.

It might be easier to create a sort field and have someone copy "Main"
over and over.