| 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
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) | |||
Hybrid Mode
