Replace Char

[ALLSEBS01]

Hi, 

I want to use the formula ReplaceChar to remove a quotation mark, however, it does not recognise it as you have to put the character you want to replace between 2 quotation marks. 

I can't use the cleanse data tool as the quotation marks appear in a column which is currency, so it would change the amount to remove all the punctuation. 

Does anyone know how else I could remove the quotation mark in this field? 

 

 

[Felipe_Ribeir0 · Accepted solution]

Hi @ALLSEBS01 

Try: replace([Planned E], '"', '')

[ALLSEBS01]

Thank you!!