How To Remove HTML tags from an excel spreadsheet

13 May 2009 Categories: Do It Yourself

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

Don't wait. Register your domain name today!

2 Responses to “How To Remove HTML tags from an excel spreadsheet”

  1. d powers 24 July 2009 at 8:41 am (PERMALINK)

    When I tried this, I get a message “Formula is too long.” The cells that I’m trying to remove HTML code from do have a lot of code.

    Author
  2. Claire Alexander 30 July 2009 at 8:30 am (PERMALINK)

    When I try this I get the message: this formula is too long.

    Author