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
-----------------------------------------------
The NoSpin Group
[log in to unmask]


> -----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"
>
> 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
>
>
> Al Thompson

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml