View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How can I cut data out of HTML table, into msExcel and just take thedata & columns? (but NOT the formatting & URLs!)

No, I haven't.

Maybe Ship will want to.

Dave H wrote:

Dave Peterson Wrote:
Paste into a helper worksheet that will preserve the formatting and the
columns.

Then copy from there, but paste special|values to its rightful home.

ship wrote:

Doesnt work!
Either you paste HTML, or you lose the columns

Ship
Shiperton Henethe

--

Dave Peterson


Have you tried a web query under data/import external data?

--
Dave H


--

Dave Peterson