|Subject:||sorting by street address|
|Posted by:||oarmaster (nobo…@adelphia.net)|
|Date:||Tue, 18 May 2004|
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.