How to delete special characters in a cell.

[Timo97]

Hello folks, 

I have a table with a bunch of text and in the text I have " characters, I need to delete them before I continue with my workflow. 

Does anyone have any idea, I have tried REGEX function alwedy but it is not working as it does not accept """ Wording. 

"Hello",0,"ciao",,,"bla",1574,"bla"

"Hello",10,,"hello2,,,123,"bla"

Thx for help

[IraWatt · Accepted solution]

Hey @Timo97,

One non regex option is just to use the replace function like this:

replace([Column1],'"',"")

This will remove all the " from your text.

[Felipe_Ribeir0]

Hi @Timo97 

If you just want to replace remove " you can use this formula

replace([Field1], '"', '')