Copy all of the titles to a helper column
Sort by the helper column
copy everything to a second helper column
for all of the Titles starting with "A ..."
in the second helper column
=right(H1,len(h1)-2)
to get rid of the A space
for all of the "An ..."
=right(H1,len(H1)-3)
for all of the "The ...
=right(H1,len(H1)-4)
copy the second Helper column and paste special values over the first helper
column and sort by this column
Whenever you add a new movie add the full title to the main list and an
appropriately modified title to the second list
and sort by the second list


"Mr B" wrote:

> 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.