Replacing HTML with plain text

[Alba_Machado]

Hey friends, is there any formula I can use to replace HTML with regular text? I’m zapping in excerpts that contain ’ where a single apostrophe ( ’ ) should be.

[ScottWorld]

You can use the SUBSTITUTE() function to replace old text with new text:

Airtable - Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...