Al,

Here's how I do it.   Examples: "Beautiful Mind, A" and "Bounty, The" Then
sort.

J. Dent


At 02:58 PM 9/22/2004, you wrote:
>Dear Listers,
>
>I have a text list of my DVD collection in MS Excel.
>I would like to sort them alphabetically - easy enough, except for movies
>that start with  " The " or "A"
>
>Currently, (part of ) the list reads as follows:
>
>A Beautiful Mind
>A Fish Called Wanda
>Alien
>Aliens
>Alien 3
>Flatliners
>Star Trek Generations
>The Bounty
>The Hurricane
>
>I would like to auto-sort the list (without having to change each cell
>manually) to read as follows:
>
>Alien
>Aliens
>Alien 3
>Beautiful Mind, A
>Bounty, The
>Fish Called Wanda, A
>Flatliners
>Hurricane, The
>Star Trek Generations
>
>Numerically-numbered movies  may come into play later, but for now a
>sorting like this would be helpful. Thanks
>kindly!
>
>Al Thompson
>
>              Do you want to signoff PCSOFT or just change to
>                     Digest mode - visit our web site:
>                    http://freepctech.com/pcsoft.shtml

              The NOSPIN Group is now accepting donatations
              to continue providing PCSOFT and our website.
           Visit http://freepctech.com to donate using Paypal