Excel Text Sorting

Exxcellent!, I can work with this.
duhg

TheAntony 

I'd modify a bit since formula not only sort but change the source text as well, plus give an error for such words as Apple not necessary each sentence starts from The or A.

Something like

=SORTBY(A3:B14,
     IFS(
         LEFT(A3:A14,4)="The ",RIGHT(A3:A14,LEN(A3:A14)-4),
         LEFT(A3:A14,3)="An ", RIGHT(A3:A14,LEN(A3:A14)-3),
         LEFT(A3:A14,2)="A ",  RIGHT(A3:A14,LEN(A3:A14)-2),
         TRUE, A3:A14
))

If Excel doesn't support dynamic arrays, add helper column with formula as IFS(...) above and sort by it. If IFS() is not available when use nested IF().