Try this:

=IF(OR(LEFT(A1,FIND(" ",A1&" ")-1)={"A","An","The"}),MID(A1,FIND(" ",A1&"
")+1,99),A1)


"Lubslimegreen" wrote:

I made a excel spreadsheet listing all the movies that I own. I'm wanting to
put them in alphabetical order. I know how to sort by ascending and
decending. My question is how do I sort so that A, AN, and THE are ignored.

Thanks!