Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 7 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.