pasting a html table into excel
 

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.

pasting a html table into excel
 

TK wrote:
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.


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

pasting a html table into excel
 

See link
http://www.vertex42.com/News/excel-web-query.html

"Franz Verga" wrote:

TK wrote:
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.


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