How To Remove HTML tags from an excel spreadsheet
I thought I would share this easy solution for removing specific html tags from excel spreadsheets:
1. Highlite the cells that contain the html tag you would like to remove.
2. Open the Find and Replace window (CTR+H)
3. Enter <*> in the “Find What:” field
4. Leave the “Replace with:” field blank
5. Click the Replace All button and all HTML tags will be removed
If you want to just remove a specific html tag, say all image tags (<img>), you would enter <img*> in the “Find What:” field. This would leave all other HTML tags except images intact.
Here are some other common HTML tags you may want to remove:
1. <*div*> removes all div tags
2. <*href*> removes all links