Excel: concatenate only non zero values


So here is what I have:

Substance quantity
Water 98
Sodium .5
Potassium 1
Calcium .5
Magnesium 0
What I need is a formula that will concatenate only the non-zero's and the substance associated with them. For example this out put should say: Water, 98; Sodium .5; Potassium, 1; Calcium .5 If this seems pointless, the reason I need a methodology because I actually have about 50 substances and there are about 30 "quantity" columns and I would like a nice way to automate this and apply it to other similar applications. Thanks.


This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of January 27, 2014.


For more resources for Microsoft Excel