KSE

I am not aware that is a built-in method to do this in Excel. Nonetheless,
this will work.

Suppose your titles are in column A on the spreadsheet i.e. start in A1 then
A2 etc.

In cell B1 type the follwoing formula:

=TRIM(IF(LEFT(A1,3)="The", RIGHT(A1,LEN(A1) - 3) & "," &LEFT(A1,3),A1))

Now drag it down for the all the tiels that you have. This should place the
titles in the format you want e.g.

The Terminator = Terminator, The

Then you can simply sort that column.

I hope this helps.

Alex


"KSE" wrote:

How do you exclude the word "the" when you want to sort a list of titles that
begin with "The". I want to put in alphabetical order, but don't know how to
sort without the "The" becoming the first word? Any help would be appreciated.