Sort and exclude certain words - microsoft.public.excel.misc

Message from discussion Sort and exclude certain words
From: jds217 <jds217.1y3yty_1131336001.6...@excelforum-nospam.com>
Subject: Sort and exclude certain words
Date: Sun, 6 Nov 2005 21:57:40 -0600
Message-ID: <jds217.1y3yty_1131336001.6988@excelforum-nospam.com>
Organization: ExcelTip
User-Agent: ExcelTipForum
X-Newsreader: ExcelTipForum
X-Originating-IP: 69.220.216.105
Newsgroups: microsoft.public.excel.misc
NNTP-Posting-Host: limelight.irubin.com 70.85.25.132
Path: g2news1.google.com!news4.google.com!news.glorb.com!news.alt.net!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
Lines: 1         


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