In Excel there is a function called Find and in VBA there is a function
called Instr. Take a look at those. Your question is a little unclear in that
you say that the string is in one cell but you want to know which cells
contain the phrase.

HTH

"jason" wrote:

I have a long string of words in one cell. Is there a
function that I can use to search a range of cells and
count the cells that contain that specific phrase?