Most valuable professional
  • Hot Topics

Excel concatenate only non zero values

So here is what I have: Substance Water Sodium Potassium Calcium Magnesium 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel