counting no. of times a character occurs in a cell

[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

 

[Mike H]

Try

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

Mike

 

[Bob Bridges]

VERY slick! I wouldn't have thought of that one.

 

[hsg]

excellent!
Never figured it out that way!

Thanks Mike, Gary's student, Ashish