View Single Post
  #5   Report Post  
Posted to alt.www.webmaster,microsoft.public.excel,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!)

You have another suggestion at your other thread.

ship wrote:

Hi

This is driving me ABSOLUTELY NUTS!

How can I keep the rows & columns of data that I am copying and pasting
off a website (my own in this case!), into a spreadsheet... WITHOUT
taking all the data formatting?

If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep
the
columns (something that doesnt happen if I paste out of FireFox, fwiw).

But it pastes with all the formatting & URLs etc - which I DONT WANT!

OK, I can save as .CSV, close, 2 warnings, and re-open but when done
REPEATEDLY this is a damned nuicance!

Any suggestions?

Ship
Shiperton Henethe


--

Dave Peterson