I want to replace all instances of html code in a spreadsheet column (it’s output of student text from Moodle).
I found how to use regular expressions in search and replace, but if I do a search for <.*> more cells are completely deleted than should be. For example, the following cell gets blanked out.
<p>I think during war , because reb background like fire.</p><p>I think poor ,because this child look gaunt.</p><p> </p>
However, the first sentence in this one remains
I think it is in the evening because the sun is set.
<p><span style="font-size: 1rem; -webkit-text-size-adjust: 100%;">I think we are in the desert because there are only two cactuses</span></p>
I don’t know programming well, but I don’t see any unbalanced <>s. I guess this will be obvious to those who know this stuff. I’ve tried everything I can think of.
Thanks for any help.
(Slightly edited by @Lupp in the hope to get a better view of the question intended.)