jds217 <jds217.1y3yty_1131336001.6...@excelforum-nospam.com>

Hi ...

I work in a public library and frequently export lists of books from
our online catalog to Excel, so that I can manipulate the data in
various ways.

My problem in sorting in Excel is this:  Our library catalog excludes
words like "The" "A" or "An" at the beginning of a title when sorting.
Excel, however, does not.

Is there any way I can sort on a field in Excel and have it ignore
certain words at the beginning of a string?

Thanks!

--
jds217
------------------------------------------------------------------------
jds217's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28608
View this thread: http://www.excelforum.com/showthread.php?threadid=482709