I encountered a problem very similar. When I would try to "find and replace" a VALUE vs. a formula, I could not choose the "value" option. I found a link that said it could be because the sheet is protected, but my sheet is NOT protected. I am searching for the word ARCADIA with two trailing spaces. I want to replace it with ARCADIA and ONE trailing space. When I look for ARCADIA?? (using ? as a wildcard), and replace with ARCADIA and a space, it worked. But I am positive I have not had to use a wildcard in the past. I've done this type of search and replace tons of times. So still don't know why this happened, but at least its fixed.
Bookmarks