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?
Thanks!
