lookup text

i want to do a horizontal lookup across 20 odd cells and pick up the value in the cell containing text. the remaining 19 cells contain question marks but can also be left blank if that makes things easier. The objective is to pick up the one value that contains text.

If the one vaue does contain text and not a number either

=HLOOKUP("*",B4:U4,1,FALSE) if the cells are blank

or if they are ?

entered as an array (holding down shift control then hiting enter to enter the formula)

=HLOOKUP("*",IF(B4:U4="?",1,B4:U4),1,FALSE)

Regards

Dav