Remove the word "The " from multiple cells so as to sort them?

[T. Valko]

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 Edit>Replace
Find what: The<space> (enter a space after typing "The"
Replace with: nothing, leave this empty
Replace All

 

[David Biddulph]

.... though of course it would do strange things to "The Day Of The Jackal",
for example.