Find first cell containing text within a row

Originally Posted by NBVC

Something like:


=INDEX(A5:K5,MATCH(TRUE,INDEX(ISTEXT(A5:K5),0),0))

where A5:K5 is your lookup range.

Exactly what I wanted, thank you very much!