How to Remove HTML Tags from Text in Excel using Find and Replace

If you have HTML tags in your Excel data, you can easily remove them using the Find and Replace feature. Here’s how:

For example:

Before After
iPhone Xs <br> iPhone Xs
iPad Pro <br> iPad Pro
<strong>Samsung Galaxy</strong> Samsung Galaxy
<p>Google Pixel <br> phone</p> Google Pixel phone
  1. Open the spreadsheet in Excel.
  2. Select the cells containing the data you want to clean.
  3. On the Home tab, in the Editing group, click on the Find & Select button.
  4. Select the Replace button.
  5. In the Find what field, type <*> to select any text surrounded by angle brackets.
  6. In the Replace with field, insert a space.
  7. Click Replace All.

By following these steps, you should have successfully removed all HTML tags from the data selected.