Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list of movies and I want to sort them by name then what stack
there in. a b Gone with the wind | stack 7 The god's must be crazy | stack 6 Except I want to ignore the word "the" in the title but still have it in the title after the list is sorted alphabetically. Easy to do? Is there a way to hide the word and it will sort OK ? Thanks for any help, Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting using a second word in a cell | Excel Discussion (Misc queries) | |||
can I ignore words when sorting excel columns? | Excel Worksheet Functions | |||
ignore #N/A in a sum? | Excel Worksheet Functions | |||
How can I ignore articles in a sort using Excel or Word? | Excel Discussion (Misc queries) | |||
Ignore #DIV/0! | Excel Worksheet Functions |