Excel Replace Function with wild card: Possible?

Hi Everyone,

I'm new to excel and I have column of data that has a lot of html tags encapsulating my text, I can use the Find & Replace tool with a wild card but the problem is I have to manually do a find & replace for all tags except <br><li><ul></li></ul>.

I need to make a Replace function that replaces all other tags with ""except those above. I tried using the replace function like so

Please Login or Register  to view this content.

but it dint work can someone help me? remove all other tags <*> except <br><li><ul>

Originally Posted by DonkeyOte

A few options (regular expressions, iteration etc etc), however, below is one route... the sub routine would be applied to active selection when invoked:

Please Login or Register  to view this content.

note: this will alter original values (test on a copy of your real data)

:O wow this is awesome. WORKS AMAZINGLY can u direct me to where I can read more about these .xCAl macro code so I can understand better?

Don't quote whole posts -- it's just clutter.

If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

mikeerickson!! yours is handy as well when I have other tags to remove that are not <> thanks !! you saved me the trouble of posting another thread