totaling text occurence from 1 cell

[Trig79]

Hi there

the below is a line of text that appears in a cell

- (CM) - (FA) - (FA) - (FA) - (FA) - (FA) - (FA) - (FA) - (FA) - (FA) - (FJ) - (FJ) - (FJ)

I am trying to set up a formula (in a separate column) that counts how many values equal FA.
I have tried COUNTIF(A1,"*FA*") but that just equals 1.

any ideas? i'm not sure if the hyphens/brackets are causing a problem or not?

thanks for help

[windknife]

Try this,

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

Hope this helps,
windknife

[Trig79]

Thank you works perfect

[zbor]

Please make thread [solved]

Go to first post -> Edit -> Go advanced -> choose solved from drop down menu