=INDEX(A1:Z1,MATCH(TRUE,A1:Z1<"",0))

This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the enter key.
--
Gary''s Student - gsnu200908


"Chad Wodskow" wrote:

I have a row of 24 cells, some are blank and others have text. I am trying
to create a formula that returns the first instance of text being used. I
have tried using a match, but it gives me an error because I am trying to
pull text not a number.

thanks