How can I replace regular quotation marks with French quotations marks in Google Sheets?

Question

I have a text with plenty of dialogue like:

"Hello" she said.

I want it to be:

« Hello » she said.

Is there a command that allows the search engine to distinguish between the first and last inverted commas? For example, something like:

Find: ".* and replace with «

Delete, Rewind.X · Accepted Answer

Replace the last inverted commas (quotation marks) first by replacing " with a space after it. Make sure you select "Match Case" and it will recognize the space and only change the last inverted commas to your » (be sure to add a space both before and after it).

Then you can simply replace all of the first quotation marks replacing " with no space after it to « (be sure to add a space both before and after it).

Then you can simply replace all of the first quotation marks replacing " with no space after it to « (be sure to add a space both before and after it).

How can I replace regular quotation marks with French quotations marks in Google Sheets?

Trending Questions