Tip of the Day | Tuesday 3 November 2026

Discover new tools to get things done.

Remove All HTML Tags in Selected Cells...

This tool removes all HTML tags from the selected cells, such as <br>, <p>, <font>, <script>, and more.

Besides removing the tags, you can choose to:

  • Add a line break after removing block-level tags like <br>, <br />, </p>, </h1>
  • Preserve existing line breaks in the cell content

It also decodes encoded characters such as &nbsp; (non-breaking space), &amp; (&), and %20 (space) to make the text easier to read.

Examples of use:

  • Clean up product or stock descriptions exported from an e-commerce platform.
  • Remove formatting tags from CMS or database exports before importing into Excel.
  • Prepare raw HTML content for plain-text use in reports, CSV files, or summaries.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Tip:Alt+P for the previous tool.