Excel Formulas to Strip HTML from Text or Numbers ~ Quick Tips!!
Tags: excelformula, excelformulas
Published: 2021-06-25 08:21:08

---
title: Excel Formulas to Strip HTML from Text or Numbers ~ Quick Tips!!
published: true
date: 2021-06-19 09:54:34 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-strip-html-from-text-or-numbers/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Strip HTML tags](https://geekexcel.com/wp-content/uploads/2021/06/Strip-HTML-tags.png)](https://geekexcel.com/excel-formulas-to-strip-html-from-text-or-numbers/strip-html-tags/#main)<figcaption id="caption-attachment-47633">Strip HTML tags</figcaption>

## Generic Formula:

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

**=[MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(text,start,[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)(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](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)**.
- **LEN** – In Excel, the **[LEN function](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)** 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.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-44.png)<figcaption id="caption-attachment-47635">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-58.png)<figcaption id="caption-attachment-47634">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-46.png)<figcaption id="caption-attachment-47636">Result</figcaption>

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Trim the Text into N Number of Words ~ Simple Tricks!!](https://geekexcel.com/excel-formulas-to-trim-the-text-into-n-number-of-words/)**
- **[How to Validate Only Numbers in Cell in Excel Office 365?](https://geekexcel.com/how-to-validate-only-numbers-in-cell-in-excel-office-365/)**
- **[Excel Formulas to Split Text and Numbers ~ Quick Method!!](https://geekexcel.com/excel-formulas-to-split-text-and-numbers/)**
- **[How to Search for a Value in All Tabs in Excel Office 365?](https://geekexcel.com/how-to-search-for-a-value-in-all-tabs-in-excel-office-365/)**