JLatham, could you help on my problem?

"JLatham" wrote:

The CONCATENATE is slick - and you can ignore my log IF() statement in your
other, duplicate, request for help on this one.

"the dave" wrote:

Thank you all. CONCATENATE worked perfectly. I'll experiment with the other
answers to learn more. thx again.

"the dave" wrote:

Thanks in advance.
Which formula would work here.
There are 7 cells. There will be 1 random text value in one cell, the others
will be blank. I want whichever text value is in the one cell to show up in
another cell.