pasting a html table into excel

T

TK

When I try to paste a talble i took from the interent into Excel, it all
pastes into one value. It just started this and i can't get it to stop! I
need it to stay in the same format as it was when i copied it. It puts
everything into one long string of info into the first block/value/space in
Excel! I would appreciate any help anyone can offer. Thank you.
 
F

Franz Verga

TK said:
When I try to paste a talble i took from the interent into Excel, it
all pastes into one value. It just started this and i can't get it
to stop! I need it to stay in the same format as it was when i
copied it. It puts everything into one long string of info into the
first block/value/space in Excel! I would appreciate any help anyone
can offer. Thank you.
Click to expand...


The best way to copy data from Internet is a web query.

Try this:

menu Data, Get External Data, New Web Query...

Then insert the URL. When the requested pages is loaded, you can select the
data to import (just follow the wizard...) and choose Import.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top