Skip to main content

IF Formula for Removal of Quotes

  • October 16, 2016
  • 3 replies
  • 59 views
A
Forum|alt.badge.img+4

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!

    This topic has been closed for replies.

    3 replies

    S

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

      A
      Forum|alt.badge.img+4
      • Andrew_Enright
      • Author
      • Known Participant
      • October 17, 2016

      Boom; worked perfectly. THANX!

      V
      • Vien_Trinh
      • New Participant
      • March 7, 2020

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

      Terms & ConditionsAccessibility statement