+ Reply to Thread
Results 1 to 5 of 5

how do you sort by street name in address?

  1. #1
    Registered User
    Join Date
    07-29-2007
    Posts
    3

    how do you sort by street name in address?

    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

  2. #2
    Forum Contributor
    Join Date
    07-10-2007
    Location
    Portland, OR USA
    Posts
    135
    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))
    Last edited by no dice; 07-30-2007 at 03:13 AM.

  3. #3
    Registered User
    Join Date
    07-29-2007
    Posts
    3
    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
    Last edited by old hickory; 08-01-2007 at 11:46 PM.

  4. #4
    Registered User
    Join Date
    07-29-2007
    Posts
    3
    old dice....
    all it says in A1 and B1 after doing as you say is "#value"

    Old hickory

  5. #5
    Forum Contributor
    Join Date
    07-10-2007
    Location
    Portland, OR USA
    Posts
    135
    Hmm... what column is your original data in? Can you attach a sample of your spreadsheet?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1