1 2 Previous Next 24 Replies Latest reply: Feb 14, 2010 10:35 PM by fruhulda
pglages Level 1 Level 1 (0 points)
I have a list where each line starts with a last name. How do I make the list alphabetical?

Thanks

MacBook Pro, Mac OS X (10.6.2)
  • 1. Re: Alphabetize list
    PeterBreis0807 Level 7 Level 7 (29,630 points)
    Download and install *Word Services,* it has a sort function amongst many other features:

    http://www.devon-technologies.com/products/freeware/services.html

    Peter
  • 2. Re: Alphabetize list
    Walt K Level 4 Level 4 (2,895 points)
    What's more, it's free.

    Walt
  • 3. Re: Alphabetize list
    PeterBreis0807 Level 7 Level 7 (29,630 points)
    My favorite price.

    P.
  • 4. Re: Alphabetize list
    Jerrold Green1 Level 7 Level 7 (28,995 points)
    pglages,

    I like Word Services too, but there is also a native way to sort. A bit of a pain but effective.

    It goes like this:

    Select the list.
    Format > Table > Convert Text to Table.
    Select the one of the table cells.
    In the Tables Inspector, Edit Rows and Columns, Sort Ascending/Descending.
    Select the Table
    Format > Table > Convert Table to Text. Now you're back to your list, sorted.

    Jerry
  • 5. Re: Alphabetize list
    pglages Level 1 Level 1 (0 points)
    Thanks guys. I haven't been able to figure out how to use WordServices. I copied it to username>library>services, restarted, selected the list in pages, then what??? Nothing seems to show to direct the sort.

    I did use Jerry's suggested process, which worked, but left odd misplaced formatting.

    Anyway, any further advice would be much appreciated.
  • 6. Re: Alphabetize list
    fruhulda Level 6 Level 6 (15,110 points)
    Using Services is a bit different in Snow Leopard. First you have to select the text 7 Object you want to do something with. Then go Services. If nothing is still in the list choose Services preferences. Select all functions you want the computer being able to use. Close the preferences. Try again. now you should see all applicable options.
  • 7. Re: Alphabetize list
    pglages Level 1 Level 1 (0 points)
    Thanks again. I'm still having some trouble with this process using Pages. The easiest way I have found so far to sort alphabetically is, regrettably, to convert it to a Word doc, do the sort, and convert it back to Pages. This should be an easy thing to do within Pages.
  • 8. Re: Alphabetize list
    Jerrold Green1 Level 7 Level 7 (28,995 points)
    pglages wrote:
    I did use Jerry's suggested process, which worked, but left odd misplaced formatting.


    pg,

    If you define a Style before doing the sort you can restore the format after sorting by applying that style to the sorted text.

    Jerry
  • 9. Re: Alphabetize list
    ywambobby Level 1 Level 1 (0 points)
    I am having a problem with sorting my data too... When I print my labels from my address book I can change the sorting order. But, when I use Pages I cannot change the order?? In other words I am only putting the first name on the letters (merge field) and because of the limited sorting selection I can't seem to get the same order from my address book and Pages merged letter. So I am spending a lot of time sorting after printing to match the letters to the labels. There has got to be a better way... Help!
  • 10. Re: Alphabetize list
    fruhulda Level 6 Level 6 (15,110 points)
    Please start your own thread as this thread isn't about merging.
    You can also look for labels, merging plus alphabetize i by search function in the forum.

    I an sorry that I can't help you on this issue, but there are folks who knows about these matters here.
  • 11. Re: Alphabetize list
    Jerrold Green1 Level 7 Level 7 (28,995 points)
    yb,

    You will have better control over your merge order if you first copy your data from address book to Numbers and merge to the Pages letters from Numbers. As fruhulda suggested, a new thread is in order.

    Jerry
  • 12. Re: Alphabetize list
    PeterBreis0807 Level 7 Level 7 (29,630 points)
    pglages wrote:
    Thanks guys. I haven't been able to figure out how to use WordServices. I copied it to username>library>services, restarted, selected the list in pages, then what??? Nothing seems to show to direct the sort.

    I did use Jerry's suggested process, which worked, but left odd misplaced formatting.

    Anyway, any further advice would be much appreciated.


    Select the text.

    +Menu > Pages > Services > Format > Sort Lines Ascending/Descending+

    If you are using OSX 10.6 you may also find the Services in your contextual menu (right mouse click on the selection).

    Peter
  • 13. Re: Alphabetize list
    iygUTFytd675E87tIUGuyf Level 1 Level 1 (0 points)
    Friends,

    As a normal part of academic reports, I sort large text blocks into separate lists.

    I purchased iWorks to avoid the excesses of Word.

    I have been unable to find an alphabetical sort function in Pages.

    I have downloaded and followed instructions in regard to Devon's application to sort in Pages.
    The applications fails to work.
    I choose not to be at the mercy of a system that I am too dumb to activate.

    Do I understand that Apple intends one to move data back and forth between Pages and Numbers to accomplish alphabetical sorting?
    Is this an intended advantage of Pages + Numbers?
    Is there an advantage to this that I fail to understand?

    Should I revert to Word?
    If so, why would I choose to work between Pages and Word to accomplish what Word can do alone?

    I welcome suggestions.

    MQPeterson
  • 14. Re: Alphabetize list
    Peggy Level 8 Level 8 (38,230 points)
    Welcome to Apple Discussions

    The very first reply to the original poster (OP) in this thread has a link to the free WordService by Devon Technologies. Installing this in the Services folder in either the main HD > Library or your home > Library & restarting Pages will give you access to alphabetical sorting & much more. If you are using Snow Leopard you need to go to System Preferences > Keyboard > Keyboard Shortcuts & enable the individual services.



1 2 Previous Next