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.