Thread: How can I ignore articles in a sort using Excel or Word?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rowan Drummond
 
Posts: n/a
Default How can I ignore articles in a sort using Excel or Word?
See this thread regarding a similar request:
http://tinyurl.com/7mdgr

Hope this helps
Rowan

Nothappy wrote:
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?
Reply With QuoteReply With Quote