I discovered a neat formula today whilst preparing my data for the first day of Dashboard Week.
If you want to clean all quotation marks from a field in your data, use the StripQuotes formula in the Formula tool. The tool’s argument is the field you want to remove all quotation marks from.