How to remove HTML markup from a body of text within a Google Spreadsheet?

Question

I am working on cleaning up text within a google doc. The challenge is that the copy contains `HTML` markup and I am trying to remove it to be left with clean text. I have created the following, but it seems to remove only the first instance of `HTML` code in the cell, how do I get it all out? ``` = regexreplace(C9,"\<[a-zA-Z0-9-?]*\>","") ```

Accepted Answer

try this regular expression :

```
= regexreplace(C9,"<.*?>","")
```

How to remove HTML markup from a body of text within a Google Spreadsheet?

Solution

Problem