Let us say you have the titles in column A:A
In an auxiliary column put the articles you want to ignore. Let us say in
K1:K3 you have "The", "A", "An".
Now, in B2 you use the following formula:
=IF(ISNA(VLOOKUP(LEFT(A2,FIND("
",A2)-1),$K$1:$K$3,1,0)),A2,IF(ISERROR(FIND(" ",A2)), A2, MID(A2,FIND("
",A2)+1,LEN(A2))))

This should strip your title name of the article, if it starts with one.
Expand the list of articles as necessary, changing the $K$1:$K$3
accordingly. Sort by column B:B.

HTH
Kostis Vezerides

"Mr B" <MrB@discussions.microsoft.com> wrote in message
news:F2947FA0-B5EA-4B95-8AD6-5D66C1870A3F@microsoft.com...
> Howdy,
>
> I have a spreadsheet with all the movies I own. I want to sort it out by
> title but I don't want it to sort based on the word The, A, An, etc. Is
> there any way to do this in Excel without typing the name with the word at
> the end?
>
> I don't want to type the names like:
> Mummy, The
> But I want it to sort based on the M.
>
> Thanks.