| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore "a(n)", "the" in A-Z sort
I'm sure it's easy, but I can't find this anywhere. I need to sort, ignoring
A, AN, THE, so everythging is in the correct alphabetical order. Any help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore "a(n)", "the" in A-Z sort
A Bob Phillips suggestion from Nov. 13th
Create a helper column and strip leading The and A and An, =Substitute(Substitute(Substitute(A1,"The ",""),"A ",""),"An","") Sort on the stripped column. Gord Dibben MS Excel MVP On Thu, 16 Nov 2006 16:44:02 -0800, jmj713 wrote: I'm sure it's easy, but I can't find this anywhere. I need to sort, ignoring A, AN, THE, so everythging is in the correct alphabetical order. Any help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore "a(n)", "the" in A-Z sort
Create a helper column and strip leading The and A and An,
But is it possible for them to remain, but still be sortable, just ignoring? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore "a(n)", "the" in A-Z sort
They will remain in the original column. Select all the relevant columns
(including the original and the helper column), sort by the helper column, and that will sort the original ignoring the bits you've stripped out. -- David Biddulph "jmj713" wrote in message ... Create a helper column and strip leading The and A and An, But is it possible for them to remain, but still be sortable, just ignoring? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accidental Sort | Excel Discussion (Misc queries) | |||
| I want to sort on titles but wish to ignore, but not delete, the . | Excel Discussion (Misc queries) | |||
| Can I ignore numbers and sort only text in an Excel column? | Excel Discussion (Misc queries) | |||
| How can I ignore articles in a sort using Excel or Word? | Excel Discussion (Misc queries) | |||
| How to ignore parens in a sort? | Excel Discussion (Misc queries) | |||
Linear Mode
