View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sedro6 Sedro6 is offline
external usenet poster
 
Posts: 1
Default How do I get Excel to ignore "a", "an", "the" when sorting?

I am maintaining a large list of books. They are customarily sorted by
ignoring the initial "A", "An", or "The" when these are the first words of a
title. Is there a rule or macro that can tell Excel to ignore them in this
position?