How to Scrub HTML from OpenOffice.org Calc

How to Scrub HTML from OpenOffice.org Calc featured image
(Last Updated On: June 9, 2014)

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 *

Silicon Dales