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
|