Forum Discussion
Excel Find and Replace can't see quotes
I am trying to use Find and Replace in Excel. I have tried all the permutations possible, multiple quotes, copy and paste the quote, and even the Tilda. Nothing works. I can find everything else to include single quotes, but I can't find the double quote. This is very frustrating...please help Gods of Excel.
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.
3 Replies
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
