I have several columns with zero values (0), and one column that contains
text value. On another cell, I would like to have a formula/function that
searches the entire row, and return only the text value. Any help is highly
appreciated.

Thanks.
--
when u change the way u look @ things, the things u look at change.