Help with formula

Topic Labels: Automations
186 1
Showing results for 
Search instead for 
Did you mean: 
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
10 - Mercury
10 - Mercury

Hi there! Try the SUBSTITUTE() function.

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