View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default How can I alphabetize data excluding words like "a" and "the"?

Hello, Faith!
You wrote on Mon, 13 Nov 2006 13:28:01 -0800:

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

You probably could do this with VBA but, for a one off sort,
you could also make a helper column with "the " and "a "
replaced by "" and sort on that. It depends, I guess, whether
you intend to do it frequently.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not