sorting by street address

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: oarmaster (nobody_at_adelphia.net)
Date: 05/18/04 

Date: Tue, 18 May 2004 12:23:18 -0400

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.

Relevant Pages