how do you sort by street name in address?

**old hickory** · 07-29-2007, 10:48 PM

I'm trying to sort voters by street address. Right now the data is sorted by voter last name. I need the streets to be sorted together alphabetically.....keeping the other data with the same address. I do not want the street number to be in the sort....just the steet name. This way...when I am going door to door....I can target a street and then look at the actual number to go door to door and be able to check off which address's I actually went to.

Any help is appreciated.

Tim

**no dice** · 07-29-2007, 11:41 PM

Insert two blank columns to parse out the street number and name so the data can be sorted by street name.

If the street address is in C1, try the following in A1 & B1

=LEFT(C1,FIND(" ",C1)-1)

=RIGHT(C1,LEN(C1)-FIND(" ",C1,1))

**old hickory** · 08-01-2007, 11:42 PM

old dice, thanks for your reply.
Please bear with me as I don't know how to do what you suggested....

I think I can create the new columns but where do I put the other functions ?I do not know

wait....i think i follow....i will give it a try thanks

Old Hickory