using countif() to parse string

[tivarney]

I am trying to use countif() to parse a cell which contains a string.
For example, the string could be "This is the example string."

Can I use the countif() to count any cells that contains the wor
"example" from the string above.

I am currently able to count the word "example" but only if it is th
only word in the cells. Any help would be appreciated.

Thank

 

[JulieD]

Hi

try
=COUNTIF(A1:A100,"*example*")

Cheers
JuileD

 

[tivarney]

Thanks for your help Juli

 

[JulieD]

glad to assist