Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I sort text (in excel) while ignoring articles (e.g., the
I work in a library and want to sort lists of CD titles. I want to sort the
list alphabetically while ignoring articles (e.g., the, a, an) when they appear as the first word in the title. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I sort text (in excel) while ignoring articles (e.g., the
Hi I don't think you can do this. what might work is to include the names in an adjacent column and eliminate the articles, then sort on that. For example, this formula will eliminate the words "The ", "An " and "A " from the left of the text in cell A1 (note the addition of a space after the word in the formula, to prevent all words begining with "A" being cropped): =IF(LEFT(A1,2)="A ",RIGHT(A1,LEN(A1)-2),IF(LEFT(A1,3)="An ",RIGHT(A1,LEN(A1)-3),IF(LEFT(A1,4)="The ",RIGHT(A1,LEN(A1)-4),A1))) -- Nicky ------------------------------------------------------------------------ Nicky's Profile: http://www.excelforum.com/member.php...nfo&userid=312 View this thread: http://www.excelforum.com/showthread...hreadid=518525 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I sort text (in excel) while ignoring articles (e.g., the
A commercial application by yours truly...
http://www.officeletter.com/blink/specialsort.html Jim Cone San Francisco, USA "happy1" wrote in message... I work in a library and want to sort lists of CD titles. I want to sort the list alphabetically while ignoring articles (e.g., the, a, an) when they appear as the first word in the title. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
How can I ignore articles in a sort using Excel or Word? | Excel Discussion (Misc queries) | |||
Import text to Excel | Excel Discussion (Misc queries) | |||
Is there a way to sort text by frequency within Excel? | Excel Discussion (Misc queries) | |||
Can you sort text in a random order in Excel | Excel Discussion (Misc queries) |