IF Formula for Removal of Quotes


#1

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!


#2

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


#3

Boom; worked perfectly. THANX!