N,

My Excel add-in Special Sort will sort data while ignoring articles
"A", "An" and "The". It also ignores misc. leading characters such as "(".
It has over 20 different sort methods not readily available in Excel.

They include sorting by numbers only, color, prefix,
middle, suffix, random, reverse, dates, decimal (ip and dewey),
length and others.
Looks and works somewhat like the regular Excel sort utility.
It comes with a Word.doc install/use file.

It is - free - just email me and ask for it. (release 1.51)
Remove XXX from my email address.

Jim Cone
San Francisco, USA
XX


"Nothappy"
wrote in message

Excel sorts my DVD library using the articles a and the as primary words. Any
title starting with the is found in the letter "t" section. Thus "The Razor's
Edge" is placed in the letter "T" instead of the letter "R" and I would like
to change this. How?