Count "," in a cell

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

Elton Law

Dear expert,

Is it possible to count "," in a cell please?

I used this ... but does not work

=COUNTIF(FO93,",")

Say below ... can it be solved?
2,5,3
22,25,5
5,2,3,4
 
Try this…

=LEN(FO93)-LEN(SUBSTITUTE(FO93,",",""))

Remember to Click Yes, if this post helps!
 
Back
Top