Start Excel's Replace (Edit/Replace or Ctrl+H) and put <* (that is 3
characters, a less-than symbol, an asterisk, and a greater-than symbol) for
your "Find what" condition and leave the "Replace with" field empty.

Rick


"maunder" wrote in message
...
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