How-To remove HTML from EXCEL 97 File?
 

When I select and copy certain texts it keeps the HTML tags and causes
the spreesheet to be clickbale sending me to a website.

Is there a way to remove the HTML code WITHOUT removing the text?

I am using OFFICE 97

How-To remove HTML from EXCEL 97 File?
 

Sub DeleteHyperlinks()
Dim Cell As Range
For Each Cell In ActiveSheet.UsedRange.SpecialCells _
(xlConstants, xlTextValues)
Cell.Hyperlinks.Delete
Next Cell
End Sub


Gord Dibben MS Excel MVP

On Wed, 22 Jul 2009 19:04:10 -0400, Pedro Sanchez IV
wrote:

When I select and copy certain texts it keeps the HTML tags and causes
the spreesheet to be clickbale sending me to a website.

Is there a way to remove the HTML code WITHOUT removing the text?

I am using OFFICE 97