To remove "The" as the first word in a helper column to be sorted
A2: 'The Cat and the Cradle
B2: =IF(LEFT(UPPER(A1),4) = "THE ",MID(A1,5,200),A1)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DLZ217" wrote in message ...
I have a list of different titles, some with words like "the" at the front
and I cant figure out how or if its possible to sort the list alphabetically
with out Excel picking up those words as the primary word to sort by. Is it
possible to make excel ignore those words when sorting? And if so how?
Thanks!