If every row began with "the", you could separate "the" from the rest of the text and place it in an adjacent column and then sort.
When that is done you could re-attach "the" to the sorted text. Also, if only some of the rows have "the" at the start, you could
use auto-filter on the rows and get just the rows which have "the" at the beginning and then massage the filtered rows to eliminate
the problem word.

--
RMC,CPA


"Tomk" wrote in message ...
is it possable in Excel to sort a list of names and ignore the word "the" in
a name.??? that is "the Cat" would be sorted as if it started with the
letter C...
--
Tomk