Count number of times text appears in a CELL

[abrig005]

What is the best way to count how many time text appears in a cell?

For example:

1a. Behavioral health issues;#19a. Relationship (spouse, failed intimate relationship, close friend, etc.);#21a. Substance Abuse (History of drug and/or alcohol abuse)

Count how many times just "a." appears

in a cell NOT a range​

I tried COUNTIF "*a.*" but that returns a 1 not 3 as in the example above

Thank you!

 

[njimack]

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

 

[Fluff]

How about
=(LEN(A1)-LEN(SUBSTITUTE(A1,"a.","")))/2

 

[abrig005]

Thank you very much that works!!!

 

[Fluff]

Glad we could help & thanks for the feedback