Counting "," in a cell

  • Thread starter Thread starter John Chow
  • Start date Start date
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
(e-mail address removed)
 
Back
Top