Results 1 to 2 of 2

Sorting multiple piece data

Threaded View

Odepust Sorting multiple piece data 09-17-2010, 03:05 AM
DonkeyOte Re: Sorting multiple piece... 09-17-2010, 03:51 AM
  1. #1
    Registered User
    Join Date
    09-17-2010
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Sorting multiple piece data

    I have addresses that I would like to sort but I would like to Sort them by the street name and not the number that precedes it.

    Ex:
    5 Sunset Gr
    12 Fox St
    33 Hemmings St
    5 Everitt St
    35 David St
    1458 Heatherton Rd

    Into

    35 David St
    5 Everitt St
    12 Fox St
    1458 Heatherton Rd
    33 Hemmings St
    5 Sunset Gr

    I've tried changing all variables to text and to try and create a custom sort but none work so far. All the options for sort come out with each being sorted by the number and not the text. All the Data is in a single column which makes a bit harder.
    Last edited by Odepust; 09-17-2010 at 03:25 AM.

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