Help

IF Formula for Removal of Quotes

3451 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I’ve been able to use nested IF formulas to strip out forbidden characters (like spaces, slashes, etc.), but cannot remove quotation marks. I suspect Airtable just doesn’t like “”".

Any help here? Thanx!

3 Replies 3
Simon_Horup_Es1
6 - Interface Innovator
6 - Interface Innovator

Have you tried escaping the quotes in the formula? E.g. SUBSTITUTE("\"", "")? I haven’t tested this, but it might work.

Boom; worked perfectly. THANX!

Vien_Trinh
4 - Data Explorer
4 - Data Explorer

Thank you. Save me lots of frustration. This must be an Airtable bug that they don’t even mention.