This works very well and seems to be a pretty straightforward approach. Thanks!

"MyVeryOwnSelf" wrote:

I have a table of about 30 columns. In each row, only one cell of the
30 has text in it. What I would like to do is add a column (say AE)
and have a formula that looks through column AA1:AD1, finds the cell
with text and returns it in AE1.

Maybe this will help:
=LOOKUP(2,1/(AA1:AD1<""),AA1:AD1)

I'm not clear about rows vs. columns in the problem statement, so modify
"AA1:AD1" in the formula as needed.