If the cells which do not contain the text value actually had "" (not
" " nor zero) from their respective formulae, then you could just do
this:

=A1 & A2 & A3 & A4 & A5 & A6 ... and so on.

Hope this helps.

Pete

On Feb 6, 12:41*pm, flying man
wrote:
Resulting from other calculations, I have a group of cells in which one
contains a text and all the others are zero (or " *").
I need to make a given cell to assume the text of the non-zero cell on that
group.

If I had number insted of text, the function "Max" would work, but it does
not with text content.