I'm working in a Google spreadsheet with a formula. I need to remove all quotation marks " from a string in cell A1.
=REGEXREPLACE(A1,"\"","")
This formula however doesn't actually escape the quotes. Thank you!
Removing all quotations marks from a string (REGEXREPLACE)
Viewed 8385
2 Answers
You need to escape the double quotation mark with another double quotation mark:
=REGEXREPLACE(A1,"""","")
However, you may use SUBSTITUTE if you just need to replace double quotation marks:
=SUBSTITUTE(A1,"""","")
use:
=SUBSTITUTE(A1; """"; )
or:
=SUBSTITUTE(A1; CHAR(34); )
or replace SUBSTITUTE with REGEXREPLACE
Related