Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Help with formula

372 0
cancel
Showing results for 
Search instead for 
Did you mean: 
rmm
5 - Automation Enthusiast
5 - Automation Enthusiast

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 1
AlliAlosa
10 - Mercury
10 - Mercury

Hi there! Try the SUBSTITUTE() function.

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