This is my first time using this web site so please bear with me.
I have an address spreadsheet. What I would like to be able to do is sort by street name.
Questions:
1) is there a way to select the number of the street and put it in its own column so I can sort by street name?
2) is there a way without taking out the street number and sorting by street name only?
ex;
3138 MESCALERO DR DHLS
3126 MESCALERO DR DHLS
3117 ARTHUR DR DHLS
3119 E ARTHUR DR DHLS
3121 ARTHUR DHLS
3125 E ARTHUR DR DHLS