Remove HTML from Text in Excel

 

To remove HTML tags in Microsoft Excel, you can use the Find and Replace function. Here are the steps:

1. Open the worksheet that contains the text with HTML tags.
2. Press Ctrl+H to open the Find and Replace dialog box.
3. In the Find what field, enter "<*>" (without the quotes).
4. Leave the Replace with field blank.
5. Click the Options button to expand the options.
6. Make sure that the Within drop-down list is set to Sheet, and the Look in drop-down list is set to Formulas.
7. Click the Replace All button.

This will remove all the HTML tags from the text in the worksheet. The "<*>" pattern in the Find what field will match any string that starts with "<" and ends with ">", which is the syntax for HTML tags. By leaving the Replace with field blank, Excel will simply remove the HTML tags from the text instead of replacing them with any other character. The options in step 6 ensure that the replacement is done in all cells of the worksheet and only on the text in formulas, not on the text in cell values.