Sorting by street address

  • Thread starter Thread starter T.L.
  • Start date Start date
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?
 
build a helper column that strips out the street name. Sort on that column.

Regards,
Tom Ogilvy
 
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
 
Back
Top