Home » Solar Destinations Hub » Removing All Quotations Marks from a String (Regexreplace)

Removing All Quotations Marks from a String (Regexreplace)

Chloe Bennett • • 1 min read
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,"""","")
3

use:

=SUBSTITUTE(A1; """"; )

or:

=SUBSTITUTE(A1; CHAR(34); )

or replace SUBSTITUTE with REGEXREPLACE

Your Answer

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.

Chloe Bennett
Author

Chloe Bennett

Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.