counting no. of times a character occurs in a cell

  • Thread starter Thread starter hsg
  • Start date Start date
H

hsg

Can a function tell the number of times a particular character is occuring in
a text string in a particular cell?

A1 contains ABCD,ACDT,AKBL,BCDF,PIZQ

I would like to count no. of "commas" appearing (",") in this cell.

hellp appreciated, thanks

hsg
 
Back
Top