In Excel 2007 is there a way to sort a column and have the sort ignore
leading "the" and "a"? For example, I have a list of titles and many of
them start with "The" as in "The Man Who Shot Liberty Valance" or a
leading "a" as in "A View to a Kill". I'd like to sort these and have
it ignore these leading words so that the first one gets sorted into the
M's and the second into the V's.

--
The major difference between a thing that might go wrong and a thing
that cannot possibly go wrong is that when a thing that cannot possibly
go wrong goes wrong it usually turns out to be impossible to get at or
repair. - Douglas Adams, Mostly Harmless