I have text in a column that contains html tags. Is it possible to get rid of it and leave only plain text? here is the example of a text:

CodePudding user response：

try:

=INDEX(IFNA(REGEXREPLACE(A1:A; "<\/\w >|<\w .*?>"; )))

or if you have more complex tags try:

=INDEX(IFNA(REGEXREPLACE(A1:A; "</?\S [^<>]*>"; )))

CodePudding user response：

Try

=TRIM(REGEXREPLACE(A1,"<.*>",""))

or

=TRIM(REGEXREPLACE(A1;"<.*>";""))