Originally Posted by vkcham van
I'm looking for a formula that will count specific word in a cell.

Let say cell a1 has "WLLWWLLLLLLWWLLLWWWLLLWWLLWWLWLWLWLLLWWW"
I want to know how many WWLL are in this cell, which is 4.

Thank you - sam

I wrote this custom function to provide the answer. It is used like so:

=COUNTSTRING(A1, "WWLL")
=COUNTSTRING(A1:A10, "WWLL")
=COUNTSTRING(A1, B1) (B1 holds the text string WWLL)

I copy all the code. I'm trying to use the countstring formula but it doesn't work for me. . I get this "#NAME?" I have "WLLWWLLLLLLWWLLLWWWLLLWWLLWWLWLWLWLLLWWW" in cell A1. Any ideas why?