Sorting by street address

T

T.L.

can anyone tell me how to sort a column by street name
when the street name is precided by the street number?
 
T

Tom Ogilvy

build a helper column that strips out the street name. Sort on that column.

Regards,
Tom Ogilvy
 
D

David McRitchie

Sort on a helper column perhaps in Col G with a formula similar to

G2:
=IF(LEN(A14)=0,"",MID(C2,FIND(" ", C2&" ")+1,99)) & RIGHT("00000" & LEFT(C2,FIND(" ",C2&" ")-1),5)

Use the fill handle to replicate the formula down.i
 
Top