Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove the word "The " from multiple cells so as to sort them?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove the word "The " from multiple cells so as to sort them?
The Doors
The Who The Beatles The Rolling Stones The J. Geils Band Try this: Select the range of cells in question Goto the menu EditReplace Find what: The<space (enter a space after typing "The" Replace with: nothing, leave this empty Replace All -- Biff Microsoft Excel MVP "James" wrote in message ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove the word "The " from multiple cells so as to sort them?
.... though of course it would do strange things to "The Day Of The Jackal",
for example. -- David Biddulph "T. Valko" wrote in message ... The Doors The Who The Beatles The Rolling Stones The J. Geils Band Try this: Select the range of cells in question Goto the menu EditReplace Find what: The<space (enter a space after typing "The" Replace with: nothing, leave this empty Replace All -- Biff Microsoft Excel MVP "James" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
"Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
sort spreadsheet, "merged cells" comes up. Find cells? Unmerge ? | Excel Discussion (Misc queries) | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
Lookup same word "value" across multiple cells | Excel Worksheet Functions |