Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How can I replace regular quotation marks with French quotations marks in Google Sheets?
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 «
1 Answer
- Delete, Rewind.XLv 73 years agoFavorite 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).
