SOLVED

Excel Find and Replace can't see quotes

New Contributor

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.

 

perrypederson_0-1656111382372.png

 

3 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@perrypederson 

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.

@Sergei Baklan 

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