How to Scrub HTML from OpenOffice.org Calc

If you’re importing and exporting content from websites via CSV it can be useful to scrub the HTML or formatting from descriptions and product details.

On OpenOffice.org Calc you can do this by going to Edit > Find & Replace

OpenOffice.org Calc Find & Replace option

Search for <.*>

Replace with: nothing

Find and replace to scrub HTML from LibreOffice.org Calc

Your content will be scrubbed of HTML formatting – at least everything that was between the relevant tags will be taken out.

This formula should also work in word processing and other documents, but be sure to save a copy before you try!

Leave a comment

No links of any kind allowed in comments - if you add any links, your comment will automatically be deleted.