I don't see a nice way to do this without using a special sorting column,
which you CAN hide...
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Mr B" wrote in message
...
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.