This doesn't work if the first word starts with an "A" or a "T". (other than
"A<space" and "The<space")

Biff

"Ron Rosenfeld" wrote in message
...
On Mon, 12 Sep 2005 16:28:03 -0700, "anteaters00"
wrote:

I would like to sort a worksheet alphabetically ascending, but certain row
has "The" or "A" at the beginning, so the rows with "The" at the beginning
are arranged under "T" and the rows with "A" are categorized under "A".
How
do I eliminate this problem without deleting "The" or "A"?

Use a helper column.

In some blank column contiguous with your table (or you can insert a
column),
enter this formula:

=IF(OR(LEFT(A2,1)="a",LEFT(A2,3)="the"),
TRIM(MID(A2,FIND(" ",A2),255)),TRIM(A2))

Then sort on this new column.

After you've done the sorting, you can delete the column.

If you need to do this frequently, you can record a macro.


--ron