Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Help with formula

594 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;", "<")