the number of rows in the column will vary.
I forgot to mention that cells A1:A4 do contain
a formula. All evaluate to an empty string
except for cell A3

Try this...

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

--
Biff
Microsoft Excel MVP


"Art" wrote in message
...
I forgot to mention that cells A1:A4 do contain a formula. All evaluate to
an
empty string except for cell A3. I don't think any of the solutions
resolve
this issue.

Sorry,
Art


"Art" wrote:

_________A
1_________
2_________
3_______Hello
4_________
5_______Hello

I have a single column range (A1:A4). One and only one of the cells
contains
a text entry (cell A3 in this example). I want to enter a formula into A5
that will return this text entry.

Thanks,
Art