Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Remove double quotes and comma from MID

Topic Labels: Formulas
613 0
Showing results for 
Search instead for 
Did you mean: 

Hi there - I’m trying to create a formula that will remove the double quotes and comma from the middle of a string, and although it works on one field, it doesn’t work on another.

IF(LEFT({Text}, 1)=’"’, MID({Text},3, LEN({Text})-2), {Text})

That works for one field, but not another. What am I getting wrong, or is there another, better way?


0 Replies 0