Thread: How can I alphabetize data excluding words like "a" and "the"?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default How can I alphabetize data excluding words like "a" and "the"?
Create a helper column and strip leading The and A and An,

=Substitute(Substitute(Substitute(A1,"The ",""),"A ",""),"An","")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Faith" wrote in message
...
I'm cataloging a list of movies, and I'd like to be able to alphabetize
the
titles ignoring words like "a" and "the." Is this possible?


Reply With QuoteReply With Quote