Selecting a text from a range of cells

[Allan Fiddler]

In D3:D10 there is one cell that has a text value, the remaining are empty or have a hyphen. In D11 I want to find and enter the text value that appears in the range, D3:D10.

Am trying nested IF statements, but getting tied up in knots. Anyone have any suggestions for me please?  Thank you.

[#2]

Hi, Allan!

You could try:

=LOOKUP(2,1/ISTEXT(D3:D10)/(D3:D10<>"-"),D3:D10)

Blessings!

[#3]

John, this is excellent...it has produced what I'm looking for. 

Now I am trying to understand the formula so that I can learn what is going on! Can you give me a clue?

Allan