Art,

Don't start another thread, you have answers in this one that work unless of
course you can tell us why they didn't work.

Mike

"Art" wrote:

Yes, but the number of rows in the column will vary. That's another problem I
have which I'm going to post now.
--
Art


"Rick Rothstein" wrote:

Given the conditions you stated, it seems this should work...

=A1&A2&A3&A4

--
Rick (MVP - Excel)


"Art" wrote in message
...
_________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

.