Thread: Remove HTML

I have a worksheet that contains over 900 products. One of the columns is the description which is exported from my shopping cart. The description that was exported contains some HTML code mixed in with the body of the description. I need to find and remove the code. The code is not always the same, but is always HTML code. PLEASE HELP!!

Thanks for the Help! however when i do that, it comes back saying that it can't find the data that i'm looking for....I must be doing something wrong...

It works fine for me. Instead of just saying it doesn't work, could you please outline very clearly the steps you are taking?

I just highlighted column L, hit Ctrl+H, put <*> in the first box and nothing in the second, then Replace All, and it was perfect.

Nice and simple suggestion, Huron.

When I did it, it removed 7,613 entries of <*>

See if the attached picture helps.

Awesome, i closed excel and then reopened it tried the same thing and it worked perfectly, thanks so much for the help...the key was <*>..fantastic!