This is driving me nuts: I’m importing events from a Google Calendar sync and it generates HTML markup from the event’s “description” field. I can’t for the life of me figure out a reasonable way to get rid of the HTML. HELP. This seems like it should be easy, but short of some kind of laborious Zapier recipe, I can’t figure it out.
That formula directly replaces certain tags with equivalent symbols (newlines, ampersands, etc.), and then REGEX_REPLACE() bulk-replaces any other HTML tags with nothing, followed by a final trim to clean up things like that second example where it starts with line breaks (which are newlines by that point).
If you don’t want the line breaks at all in the final output, then use this slightly shorter version: