On Tue, 13 Sep 2005 00:15:20 -0400, "Biff" wrote:

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

Good pickup. (Although it would work properly with "T"; you probably meant
"The"

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

should work.


--ron