Sorting in Calc -- How to ignore the leading "the"

[FleurdeSaison]

When I sort phrases in Calc, the leading "the" of any phrase is always used to sort them. Is the any way to ignore it when sorting?

[Villeroy]

I tested with A1:A5
almighty
thealmighty
the almighty
The almighty
the,almighty
B1 =IF(ISNUMBER(SEARCH("^[tT]he\>";A1));SEARCH("\<[:alnum:].+";A1;4);1)
C1 =MID(A1;B1;LEN(A1))
Now you can sort by column C
C returns the part starting at the position, calculated in B
B1 tests if A1 starts with "The" or "the", followed by a word-boundary.
If this is true, then it returns the position of the next word-boundary, followed by some alphanumeric chars, otherwise it returns 1.
See help on regular expressions.
_________________
XUbuntu 9.04, OOo 3.1.1(Sun), Sun Java 1.5.0_06

[FleurdeSaison]

Thanks for your help!