Using Excel to analyze HTML

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

It might sound a little weird, but I find Excel useful for
analyzing/reformatting HTML for various purposes, such as generating a list
of the links or images in a webpage. My problem is, I can't easily and
consistently get Excel (2000) to stop INTERPRETING the code. I have tried
Paste Special > Values. I have to remove a lot of the code in Notepad first,
THEN paste it, to be able to work with it in Excel. Is there any way to turn
off the default "Interpret HTML like a browser" option?

MS Word has the same problem. Any solutions for that too?

TIA,

Gregg Roberts
 
Hi Gregg..........

I'm not much of an HTML user, but my Lady does a bit of it on WEBTV, and she
suggested that if you disable the HTML header and footer, then the rest of
the code would just become regular TEXT rather than HTML until you later,
after editing, replaced them.

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top