Removing all quotations marks from a string (REGEXREPLACE)

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!

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