Search and replace double quotes

[prashgames]

how to substitute double quotes in a field?

SUBSTITUTE([COLUMN],“text to search”,“text to replace”)

column:

columnname

text to search is (") double quotation mark

"

text to replace(exclamation mark)

!

I tried 3 double quotes("""), but still gets error…
how to do this, or is there any work around available?

Sample

SUBSTITUTE([NAME],""","!")

Example field:

ALPHA-"-BETA

Expectation:

ALPHA-!-BETA

comments are welcome

[LeventK]

@prashgames
How about this:

SUBSTITUTE([NAME],"_"_","_!_")

[prashgames]

LeventK:

SUBSTITUTE([NAME],"_"_","_!_")

Expression ‘SUBSTITUTE([NAME],""","!")’ could not be parsed due to exception: Unterminated string.

[Steve · Accepted solution]

Try:

SUBSTITUTE([NAME], '"', "!")

[prashgames]

SUBSTITUTE([Instagram Name],’"’, “”!")
SUBSTITUTE([Instagram Name],’"""’, “”)

both above format works… (’ " ') & (" “” ")