Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to sort journals, or magazine titles (many thousands of them) for
some library work. Some start with the word "The" and some just start with the word "Journal" while others start with other words. I want to sort them alphabetically but ignore the word "the" without deleting that word. Is there a way to sort by putting a wild card, space, or something in to ignore it? thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Sort by column problems | Excel Worksheet Functions | |||
How to sort on data field | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |