Hello,

Wondering if someone would be kind to point me in the right direction and/or help me with:

How to display exact count of particular keywords (words that I would like to specify) and search against the worksheet. Column that needs to be searched contains a lot of characters (words) per cell. (can be 100 plus words). Count result should display data next to its appropriate cell.



how to display data how (result would be 2 if I specify search keyword "how")

how to how data how how (result would be 4 if I specify search keyword "how")

to search data for (result would be 0...)

--------

Thank a lot!