How to delete HTML from spreadsheet ?

[Will]

someone has given me a spread sheet that has HTML in it...

It was a web page table... and created by right clicking on the web page and
choosing view source... then saving the notepad file as an xls file.

I want to get rid of all the html so we just have the table data saved as a
normal spreadsheet.

thanks for any help

 

[Peo Sjoblom]

You can import tables from webpages using data>import external data>new web
query
using notepad is not a good way to go
If the table you have looks ok can't you just select the table and copy to
a new sheet?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Bruce Sinclair]

You can import tables from webpages using data>import external data>new web
query
using notepad is not a good way to go
If the table you have looks ok can't you just select the table and copy to
a new sheet?

Not sure exactly what they are wanting to do, but if you copy something
containing html, you can 'paste special'/'text' to leave only the data.



Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)