You could always put your street number & street name in separate cells.
I was hoping for something else. Maybe the simplest solutions are the
best??
If you come up with better, please post, it sounds like the type of info I
may need at some point at work.


"tapndog" wrote in message
...
I have clients listed in alphabetical order, name in column A, type in B,
street address in column C, ect. I want to sort my list by addresses,
preferably the street number and name as follows... Wilson 138 Arnold
Dr.
KIng 140 Arnold Dr.
Davis 189 Arnold Dr.
Lang 103 Bell Creek
Morris 285 Burtman Road.