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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top