How to remove HTML tags from Microsoft Excel file

1146085 pts.
Tags:
HTML
Microsoft Excel
An Excel file was recently given to me that has cells with text (which include HTML tags). This file was exported from one of our databases and those tags were included. I need to remove it. How can I remove all of the tags?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Find and Replace function in Excel may solve this problem, please do as follows:

1. Select the cells that you want to remove the HTML tags.

2. Hold Ctrl + H keys to open the Find and Replace dialog box, in the dialog, in the Find what text box, type <*>, and leave the Replace with text box blank

3. Then click Replace All button, all the HTML tags are removed at once.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    If you are referring to hyperlinks that take you to a web location when the cell is clicked, check out the Microsoft support page here for step by step instructions.
    133,675 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: