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?
|