thanks @PeterJones , now i can reproduce.
(i barely use excel so i didn’t even now that you can put a tab or a new line in a cell ;-) )
now i definitively second your first suggestion using regex to replace the pairs of quotes:
If you only want to get rid of matched quote pairs, then enable search mode = regular expression, and set find what=“([^”]*)" and replace with=$1. (edit: to clarify, the quote marks around the parenthesis are part of the search-string, so you should type those, too)