Excel Formulas to Strip HTML from Text or Numbers ~ Quick Tips!!

If you have a worksheet contains text strings that are surrounded by HTML tags. Now, you want to remove all the HTML tags from the strings to make the cells clearly and more readable. Do you have any good methods for solving this task in Excel? Here we will show the simple formulas to strip all the HTML tags from the text or numbers in Excel. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

You can use the below formula to remove all the HTML tags from the text strings in Excel.

=MID(text,start,LEN(text)-markup_len)

Syntax Explanations:

MID – This function helps to return the smallest numeric value from the range of input values. Read more on the MID function.
LEN – In Excel, the LEN function returns the length of a given text string as the number of characters.
Text – It represents the input text value.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

First, we will enter the input values in Column B.
Now we are going to remove the HTML tags from these input values.

Select any cell and type the above-given formula.

Finally, press the ** ENTER** key, you can get the result as shown below.

Verdict:

Here we have described the simple formulas to strip the HTML tags from text or numbers in Excel. Hope you like this article. If you have any doubts , don’t forget to share them with us.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **