Counting "," in a cell

J

John Chow

I frequently have to count a value (constant) in a cell to determine the
formula in another column:

say {cell A1}=15,16,27

I would need to insert in another cell, say {cell B1}=100*[(no. of ",") in
A1].

Would very much appreciate if anyone may enlighten me on the above.

Regards
John Chow
[email protected]
 
Top