Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Remove HTML Tags from Text in Excel (2 Suitable Ways)

HTML tags are pretty common when working with raw data. Generally, when we copy data from somewhere else, the code inside the data gets copied too. But, as users, we only need the main texts without the HTML tags. So, in this article, I will show you how to remove HTML tags from a text in Excel.


Download Practice Workbook

You can download our practice workbook from here for free.

HTML File:

Excel File:


2 Suitable Ways to Remove HTML Tags from Text in Excel

Say, you have a dataset of text in an HTML file.

Sample HTML File

Now, you have copied and pasted the text into Excel. And now, you are getting the text with HTML codes. But you don’t need this.

Excel File with HTML Tags

Now, you can remove these HTML tags from a text in Excel by following the described ways below.


1. Remove HTML Tags Using Find and Replace Tool

The simplest and quickest way to remove HTML tags from Excel is to use the Find and Replace tool. Follow the steps below to accomplish this.

📌 Steps:

  • First, select the cells (B5:B9 here) where your texts with HTML tags are present.
  • Subsequently, press Ctrl + H on your keyboard.

Access the Find and Replace Window to Remove HTML Tags from Text in Excel

  • As a result, the Find and Replace window will appear.
  • Following, go to the Replace tab >> insert <*> in the Find what: text box >> Leave a blank in the Replace with: text box >> click on the Replace All button.

Find and Replace Window to Remove HTML Tags from Text in Excel

  • Consequently, a Microsoft Excel dialogue box will appear showing you the information about replacements.
  • Subsequently, click on the OK button.

Microsoft Excel Dialogue Box

Thus, you will be able to remove HTML tags from the texts in Excel and the final outcome would look like this.

Removed HTML Tags from Text in Excel

Read More: How to Add Tags in Excel (2 Simple Ways)


2. Use VBA Code to Remove HTML Tags from Text in Excel

Furthermore, you can use a VBA code to remove HTML tags from texts in Excel. Follow the steps below to do this.

📌 Steps:

  • First, go to the Developer tab >> Visual Basic tool.

Access the Visual Basic Tool

  • As a result, the VB Editor window will open.
  • Subsequently, go to the Insert tab here >> click on the Module option.

Insert a Module to Remove HTML Tags from Text in Excel

  • As a result, a new module named Module1 will be created.
  • Now, go to Module1 >> insert the following code in the code window >> press Ctrl + S on your keyboard.
Sub RemoveHTMLTags()
    Dim lookupRange As Range
    Dim lookupCell As Range
    Dim lookupAddress As String
    On Error Resume Next
    lookupAddress = Application.ActiveWindow.RangeSelection.Address
    Set lookupRange = Application.InputBox("Select your data range", "Remove HTML Tags", lookupAddress, , , , , 8)
    Set lookupRange = Application.Intersect(lookupRange, lookupRange.Worksheet.UsedRange)
    If lookupRange Is Nothing Then Exit Sub
    lookupRange.NumberFormat = "@"
    With CreateObject("vbscript.regexp")
        .Pattern = "\<.*?\>"
        .Global = True
        For Each lookupCell In lookupRange
            lookupCell.Value = .Replace(lookupCell.Value, "")
        Next
    End With
End Sub

VBA Code to Remove HTML Tags from Text in Excel

  • Consequently, a Microsoft Excel dialogue box will appear.
  • Subsequently, click on the No button.

Microsoft Excel Dialogue Box

  • As a result, the Save As window will appear.
  • Following, choose the Save as type: option as .xlsm file and click on the Save button.

Save As Window

  • Now, close the VB Editor.
  • Afterward, go to the Developer tab >> Macros tool.

Access the Macros Tool to Remove HTML Tags from Text in Excel

  • As a result, the Macro window will appear.
  • Following, click on the RemoveHTMLTags macro and click on the Run button.

Run Macro to Remove HTML Tags from Text in Excel

  • Consequently, the Remove HTML Tags window will appear.
  • Now, put cell reference B5:B9 in the Select your data range text box and click on the OK button.

Remove HTML Tags Window

As a result, the HTML tags from your texts will be removed and you will get the desired output which should look like this.

Removed HTML Tags from Text in Excel

Read More: How to Add Tag to Properties in Excel (with Easy Steps)


Conclusion

So, in this article, I have shown you 2 suitable ways to remove HTML tags from text in Excel. You can also download our free workbook to practice. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to comment here.

And, visit ExcelDemy to learn more things about Excel! Have a nice day!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo