remove HTML tags from cell strings : excel Formula

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

I have a Data with HTML tags in excel sheet like below:

<b>This is test data<br>Nice
<div> Go on this is next Cell
Very goood <b>.....</b>

SO, Basically I want to delete or replace all html tags with space in excel sheet.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1 Answer

深蓝 · Answer 1 · 2021-10-23T19:22:56+0000

Apply Replace All with <*> pattern:

replace tags pattern

To open this go to Ribbon Home > Find & Select > Replace... or simply press CTRL+H.

Extra spaces may be further removed using TRIM function. Good luck!