How to Scrub HTML from OpenOffice.org Calc

Linda ScottDesktop Tutorials, Tutorials0 Comments

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

OpenOffice.org Calc Find & Replace option

Search for <.*>

Replace with: nothing

Find and replace to scrub HTML from LibreOffice.org Calc

Find and replace to scrub HTML from LibreOffice.org Calc

Your content will be scrubbed of HTML formatting.

Leave a Reply

Your email address will not be published. Required fields are marked *