Find and Replace is not working

I was able to use "find and replace" to find out the specific text/number in excel sheet in the past.

But recently the function is not working, look like...

Alternately I need to copy+paste to new worksheet, then only can find the text.

Is there some setting issue or "find and replace" is not able to look for specific text/number in the cell contain formula?

Fina and Replace snapshot


Solution 1:

You need to change "look in", instead of formulas, select values.

enter image description here