Sorting by name but ignore the word The
I have a list of movies and I want to sort them by name then what stack
there in.
a b
Gone with the wind | stack 7
The god's must be crazy | stack 6
Except I want to ignore the word "the" in the title but still have it in the
title after the list is sorted alphabetically.
Easy to do? Is there a way to hide the word and it will sort OK ?
Thanks for any help, Rich
|