Hi,

You could have the name without the A or THE in a separate column and order
on that column.
Eg:
-Names are in column A starting in row 1
-In column B (or whatever), cell B1 enter the formula:
=RIGHT(A1,LEN(A1)-(2*(LEFT(UPPER(A1),2)="A "))-(4*(LEFT(UPPER(A1),4)="THE
")))
-- returns the name without "THE " or "A ". Note: carefull when typing
it -- there is a space after THE and after A.
-Copy/paste B1 down along the data
-Order that new column
--
Regards,
Sébastien


"Ronnie" wrote:

How can I sort a list of movies alphabetically, ignoring words like 'THE' and
'A'