My suggestion is to inster one column and put the formula
=IF(LEFT(A1,3)="the",MID(A1,5,100),IF(LEFT(A1,2)=" A ",MID(A1,3,100),A1))
then sort all.
Click yes if helped
--
Greatly appreciated
Eva


"Pablo" wrote:

I need to sort text strings the may begin with "A" or "The". In these cases I
would like for the sort to ignore the "A" or "The" and sort based off the
second item in the string. Can you set preconditions to the sort?

Example:
The Big Blue Boat
A Tree Grows in Brooklyn
Giant
Four Score is Twenty Times Four


Results:
The Big Blue Boat
Four Score is Twenty Times Four
Giant
A Tree Grows in Brooklyn