Alphabetize a list disregarding articles such as "a" or "the"

[aemilyl]

Hi, I wanted to know how to alphabetize a list, but disregarding articles in
the beginning of a title, such as "a", "the" etc... I know how to
alphabetize them, I was just wondering if anyone knew of an option to
disregard those in the beginning. (I am alphabetizing a list of DVDs, but
you shouldn't put something like "The American President" under the T's, it
should be with the A's). Any help is appreciated!

 

[Doug Robbins - Word MVP]

Use a couple of Wildcare Edit>Replaces using

(The) ([A-z ]{1,})

in the Find what control, and

\2, \1

in the Replace with control

That will change

The American President

to

American President, The

Then do another one in which you replace the (The) in the suggestion above
with (A)

Then you can sort your list
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP