Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort Parameters
I have a list of different titles, some with words like "the" at the front
and I cant figure out how or if its possible to sort the list alphabetically with out Excel picking up those words as the primary word to sort by. Is it possible to make excel ignore those words when sorting? And if so how? Thanks! |
#2
|
|||
|
|||
To remove "The" as the first word in a helper column to be sorted
A2: 'The Cat and the Cradle B2: =IF(LEFT(UPPER(A1),4) = "THE ",MID(A1,5,200),A1) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DLZ217" wrote in message ... I have a list of different titles, some with words like "the" at the front and I cant figure out how or if its possible to sort the list alphabetically with out Excel picking up those words as the primary word to sort by. Is it possible to make excel ignore those words when sorting? And if so how? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |