lundi 9 avril 2018

how to concatenate multiple cells but return value only from cell having data

Need answer to below please....

I have 4 different cells in a row and out of those 4 cells only one cell has text and the rest of cells have 0 in it, i want to concatenate/combine those 4 cells(not in a consecutive range) and return only value from the cell which has text and not zero

Aucun commentaire:

Enregistrer un commentaire