View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich[_7_] Rich[_7_] is offline
external usenet poster
 
Posts: 6
Default 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