How to retrieve a non-blank text value in an array of text values where only one value is non-blank text

[landish]

Hi everyone, I've got an array of text values like this {"","","","words,""} HOWEVER I don't know "words" value's position in the array it might look {"","","","",words} or {"","words,"","",""}. I need to retrieve only "words" value using formula functions. It can be done either by merging all the values in the array or by sorting values so "words" value is in the first position then I can use T() function. But I can't find any function or combination of functions to do this. Thank you in advance.

 

[landish]

This way to solve a problem is great too. Thank you very much!

or

=INDEX(A1:H1,MATCH("?*",A1:H1,0))