Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel file that has cells with text that includes HTML tags.

The data was exported from a database and the HTML tags were included.

The HTML is stored as text, but I need it gone.

Is there a quick easy way to remove it all (other than find/replace)?

share|improve this question
    
This could probably be done with VBA, but it would be really helpful if you could post a few rows of the text so we could see a pattern and work the solution around it. – Michael Oct 7 '10 at 22:09
    
What is the matter with find/replace? Replacing "<*>" with "" is pretty effective. – Mike Fitzpatrick Oct 7 '10 at 23:41
    
@Mike Fitzpatrick - Can you use wild cards in find replace? (If so that would work.) – Vaccano Oct 8 '10 at 2:47
    
Yes, you can use wildcards in Excel. See my answer below. – Mike Fitzpatrick Oct 8 '10 at 5:35
up vote 8 down vote accepted

Try using Excel's search/replace with wildcards. You can use * to match any string (including empty string) or ? to match a single character.

So using:

Find what: <*>

Replace with: leave blank

will remove HTML tags from your cell contents.

share|improve this answer
    
Thanks for the tip. I did not know that Find Replace could support wild cards. – Vaccano Oct 8 '10 at 15:04
    
Didn't know you could use wildcard like this in F/R in Excel. Very useful! – Matt The Ninja Nov 12 '15 at 10:52

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .