How can I ignore articles in a sort using Excel or Word?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
(e-mail address removed)


"Nothappy" <[email protected]>
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?
 
Back
Top