Find a specific word in a comment with a formula in an excel report

In some of my reports, I need to find a particular word which is hidden into many comments, it can be in a cell, in a row and/or in a column.

formula excel


When I use the formula ?

When I need to find a word into huge comments.


How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".


How are the formulas ?






To look into a specific cell:


It will look into the cell A2 and if it finds the word “chocolate” in the comment, it will display “yes”.

To look into a specific column:


To search with 2 words or more, I will use this formula:


If you are using a cell reference instead of the word:


The cell Z2 is “chocolate”. And ff you get an error like that #VALUE!, use the =IFERROR() function:


Interesting Management