Word, Excel, Access?
I'm not sure of the problem. if titles are already in alpha order, what more do you need to do? Can you give a few examples of what you see against what you want to see?
FYI I created an Excel database, (not the best way to create a database I admit), for a friend a few years ago of his CD and record collection. We had a difference of opinion about Alpha lists. Examples below.
I said that, The Beatles, The Rolling Stones, The Cure, etc, should all be listed under T. He disagreed and said that they should be listed under B, R and C respectively, etc.
The argument he tried was Oasis. He said you wouldn't list them under The Oasis. But that didn't work for me because Oasis is Oasis, and not The Oasis. However, The Beatles are not known as Beatles, or "Beatles, The". They are known as The Beatles.
We still disagreed, so I coded it his way. He was the customer after all, but I was muttering under my breath all the way.
I am trying to catalog my collection of CDS and am copying data from the Net. Titles are already alphabetized, BUT with the initial "A", "An", "And" or "The" in the correct order. A re-sort of the data will put the tiles out of accepted order. Is there a way for me to "ignore" the first word of the title in order to get a "true" alpha list of the titles?
Many thanx in advance,