How to remove HTML markup from text text in a Google spreadsheet?

I am working on clearing text inside a google document. The challenge is that the copy contains markup HTML, and I'm trying to remove it so that it is left with clear text.

I created the following, but it seems to only delete the first code instance HTMLin the cell, how can I do all this?

= regexreplace(C9,"\<[a-zA-Z0-9-?]*\>","")
+5
source share
1 answer

try this regex:

= regexreplace(C9,"<.*?>","")
+7
source

All Articles