How can the SUBSTITUTE function replace a double quote?

[Florence]

I'm trying to use the SUBSTITUTE function to replace a double quote (") with
a regular text. The function works well with other special characters but
not the double quote.

 

[Toppers]

TRY:

=SUBSTITUTE(A1,"""","your_text*")

 

[T. Valko]

Use 4 double quotes: """"

A1 = "Biff"

=SUBSTITUTE(A1,"""","")

returns: Biff

Biff

 

[Pete_UK]

Try this:

=SUBSTITUTE(A1,CHAR(34),"xxx")

With the string "Hello" in A1, this returns xxxHelloxxx

Hope this helps.

Pete

 

[robotman]

Use CHAR(34) everywhere you want a double-quote:

Example:

=SUBSTITUTE(G14,CHAR(34),"#")

 

[Harlan Grove]

I'm trying to use the SUBSTITUTE function to replace a double quote (")
with a regular text. The function works well with other special
characters but not the double quote.

A1: "This" is a "test".
A2: =SUBSTITUTE(A1,"""","|") returns |This| is a |test|.
A3: =SUBSTITUTE(A1,CHAR(34),"|") returns |This| is a |test|.