Peter and John...

The problem is that I already typed out the entire collection thinking Excel would have a simple way to sort it
out. As you suggested, John, it would have been smarter to type it correctly the first time and sort it later, but
hindsight is always 20/20. I attempted to use the formula you provided, Peter, but to no avail - I'm a little
Excel-challenged. Anyway, I guess I'll be re-typing my list. Thanks for trying to help, guys!

Al Thompson


John wrote:

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

J. Dent

Peter wrote:


> Do you want to only sort that way, or do you want to reformat the text? In
> either case, you can create a macro to do the formatting. The difference
> would be that to only sort that way, you would need to include a sort
> routing within the macro. The general form of the macro would be:
>
> IF LEFT(cell_to_check,2) = "A " THEN
>   cell_to_check = MID(cell_to_check,3) & ", A"
> ENDIF
>
> Do the same for detecting the word "The " at the beginning.
>
> Hope this gets you started.
>
> Peter


> > -----Original Message-----
> > 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"
> >
>snipped for brevity

               The NOSPIN Group Promotions is now offering
              Mandrake Linux or Red Hat Linux CD sets along
             with the OpenOffice CD...  at a great price!!!
             http://freepctech.com/goodies/promotions.shtml