Search and replace double quotes

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

@prashgames
How about this:

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

Try:

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

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

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

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