Remove double quotes and comma from MID

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!