Alphabetizing without using the word THE or AN

[Oithematt]

Is there a way to make the sorting function ignore "THE" and "AN" when alphabetizing a list?

[GeoffW283]

How about creating an additional column with "the" and "an" stripped and then sorting on that new column?

For example if your list starts in A1, then something like the following formula in B1 copied down:

Please Login or Register  to view this content.

sort.png