7

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

Improve this question
1
  • The Look in list selection is incorrect. – Lee 14 hours ago
7

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

enter image description here

Improve this answer
2
  • Ahhhh....how silly am I ...Thanks for clear my doubt. It's working fine now. – shirleyMY 14 hours ago
  • This is such a common mistake now, I don't know why Excel changed this. You have to select "Values" every time. – user8356 1 hour ago

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.