Thread: How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
View Single Post
  #5   Report Post  
Dave H Dave H is offline
Member
  
Posts: 54
Default
Quote:
Originally Posted by Dave Peterson
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?
Reply With QuoteReply With Quote