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?
1 Answer
You need to change "look in", instead of formulas, select values.
