How do you alphabetize street addresses within a column?

R

Rosemarie

How do you alphabetize street addresses within a column? When I sort
according to address, it sorts according to the number (not the street name).
It is more important to group the street names than the street numbers.
HELP!
 
D

Dave Curtis

Hi,

An easy way is to create two new helper columns, one containing the number,
the other containing the street name.
Assuming the numbers and names are in column A,then put

=--LEFT(A1,FIND(" ",A1,1)) in B1 and drag down.

Put

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) in C1 and drag down

Then sort on column C, making sure you expand the range to include column A
and B in the range.

Dave

url:http://www.ureader.com/msg/104236262.aspx
 
D

DAP

I have the same issue, except the addresses and the street names are
referenced from another sheet using the offset command. How do I separate the
numbers from the street names?
 
Top