Count "," in a cell

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
 
M

Ms-Exl-Learner

Try this…

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

Remember to Click Yes, if this post helps!
 
Top