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,"""","")
3

use:

=SUBSTITUTE(A1; """"; )

or:

=SUBSTITUTE(A1; CHAR(34); )

or replace SUBSTITUTE with REGEXREPLACE

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.