Hi,

A chemical problem: I would like to be able to count the number of heavy atoms from chemical formulas. As an example, the formula C5H8N2OF contains 9 heavy atoms (anything other than hydrogen). Relevant heavy atoms are: C, N, O, S, F, Cl, Br and I.

Any help with coding this in Excel would be appreciated!

Pennypacker