Sorting by street address

[T.L.]

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

 

[Tom Ogilvy]

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

Regards,
Tom Ogilvy

 

[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