Does anyone know how to strip html tags from excel worksheets?
I regularly use a worksheet, (generated by IT from the web), that
creates an excel sheet. The problem is, the html tags remain, making
it very difficult to read. A sample is below:-

<ul <pUnable to log as showing up too earlyin workstream.</p</ul


I have tried using search and replace, but this does not delete all
the tags. For instance, when it encounters a <div tag, it generates
the error, 'formula is too long'

I would like to be able to strip ALL tags from the sheet using a
macro. Can anyone help?

Thanks,

Karl