how to count if cell "contains" a word

[Ron Rosenfeld]

Okay, I think this is where we are looking at the problem differently. I
read into the OP's examples that his delimited text were **all** 4
characters long. For that interpretation, the commas cannot affect the
search as there would be no way to get a false positive under that
condition.

Note this response of the OP to an effort of mine in which I posed that
question:

Unfortunately, not all the values are four characters.

--ron

 

[Rick Rothstein \(MVP - VB\)]

Okay, I think this is where we are looking at the problem differently. I

Note this response of the OP to an effort of mine in which I posed that
question:

I had not read that response (which he posted earlier in the day that Harlan
responded to me), so I was still laboring under the impression I had formed
from my first reading of the original post when I responded to Harlan (which
I think is obvious from the arguments I used in my responses to Harlan).
Thanks for pointing that out.

Rick

 

[Rick Rothstein \(MVP - VB\)]

Given Ron's posting to my last message to you, please disregard my last
several postings. It appears you were aware of the OP's posting to Ron
mentioning that the items were not restricted to 4-character each and,
having not read that message, I was not.

Rick