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
|