View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
davidandmary davidandmary is offline
external usenet poster
 
Posts: 1
Default I want to sort on titles but wish to ignore, but not delete, the .

I am trying to sort journals, or magazine titles (many thousands of them) for
some library work. Some start with the word "The" and some just start with
the word "Journal" while others start with other words.
I want to sort them alphabetically but ignore the word "the" without
deleting that word.
Is there a way to sort by putting a wild card, space, or something in to
ignore it?
thank you.