Forum Discussion
Excel Find and Replace can't see quotes
It looks like within the text are curvy quotes and you try to find "normal" quotes. To find curvy quote enter in Find what bar Alt+0147 (on numpad) for opening curvy quote and Alt+0148 for closing one (if you are on Windows). Or copy/paste them from the text.
It looks like within the text are curvy quotes and you try to find "normal" quotes. To find curvy quote enter in Find what bar Alt+0147 (on numpad) for opening curvy quote and Alt+0148 for closing one (if you are on Windows). Or copy/paste them from the text.
Yes, that seems to be it. I was haunted by curvy quote marks! Thanks so much, Sergei. This will save me a lot of time. I did try to copy and paste the quote marks into the Find window, but that didn't work. However, the Alt+0147/0148 worked perfectly.
perrypederson , you are welcome, glad to help