sorting by street address

  • Thread starter Thread starter oarmaster
  • Start date Start date
O

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.
 
Hi
you have to separate the values. Excel can't sort by street name if you
preced it with a number
 
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.
 
Back
Top