Strip html from text or numbers

To strip HTML or other markup from values in cells, you can use the MID function. In the example shown, the formula in C5 is: =MID(B5,4,LEN(B5)-7)

April 14, 2025 · 1 min · 48 words · Mrs. Gina Rodriguez

Table of Contents

Explanation

The MID function returns characters using a fixed starting point and ending point.

With these arguments, MID extracts just the text between the two tags and returns the result.

For example, =MID(“apple”,2,3) returns “ppl”.

Excel formula: Remove leading and trailing spaces from text

LEN will also count characters in numbers, but number formatting is not included.

Excel formula: Split text and numbers

Excel MID function

Excel LEN function