sorting by street address

Giganews Newsgroups
Subject: sorting by street address
Posted by:  oarmaster (nobo…
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.