Skip to main content

Help with formula

  • May 31, 2024
  • 1 reply
  • 19 views
R
Forum|alt.badge.img+4
  • rmm
  • Known Participant

Hello Everyone,

I am wondering if there is a formula to replace these characters "&lt;"  and "&gt;" that take the place of the "<"  and ">" when I import a CSV from Webflow into Airtable. Mailchimp is not able to read it as is. 

Thanks very much! 

1 reply

A
Forum|alt.badge.img+19
  • AlliAlosa
  • Inspiring
  • June 1, 2024

Hi there! Try the SUBSTITUTE() function.

SUBSTITUTE(SUBSTITUTE({Field Name}, "&gt;", ">"), "&lt;", "<")

Terms & ConditionsAccessibility statement