sorting by street address

[oarmaster]

I'm a neophyte at excel and can find no way to make this sort properly
except to put the street number in a separate cell from the street name. If
you put 25 South St, 76 Main St, and 100 Main St into three cells in a
column, it sorts as 100 Main St, 25 South St, and 76 Main St. Am I using an
incorrect format? What am I doing wrong?
Thanks in advance for any help you can give me.

 

[Frank Kabel]

Hi
you have to separate the values. Excel can't sort by street name if you
preced it with a number

 

[David McRitchie]

Hi "oarmaster" <[email protected]> ,
You can separate the two by inserting a column to the right, and
then using SepTerm macro in
http://www.mvps.org/dmcritchie/excel/join.htm#septerm

If you want a non macro solution you can use something like:
E2: =TRIM(LEFT(D2,FIND(" ",D2)))
F2: =RIGHT(D2,LEN(D2)-FIND(" ",D2))
Other solutions available if you you'd rather not use up two sort
columns.

My guess is that email address you used is a valid email address and
also that it is not you.