Copy and Paste from Web Site
 

If there is a table of figures on a web site, is there a way to copy and
paste into Excel so the figures stay in the same columns as on the site, and
can be worked on as numbers within Excel.

Paste Special sometimes works (by pasting as Text, Unicode Text or even
HTML) and sometimes it doesn't (all the data gets pasted into column A and
not spread across columns).

I realize this might be a function of how the HTML is written on the web
site, but is there some conversion tool out there which will yield consistent
results?

Tx for your help and suggestions.

I've had similar problems and learned that in my case this happened when I
had used the text-to-columns wizard in between times of importing data grids.
It's strange, but I had to make sure my most recent use of the wizard was as
"delimited by tabs option" then shut down Excel then go back in. Then try
your web query import again and it should work. Hope this helps...

steve

"Tenacity" wrote:

If there is a table of figures on a web site, is there a way to copy and
paste into Excel so the figures stay in the same columns as on the site, and
can be worked on as numbers within Excel.

Paste Special sometimes works (by pasting as Text, Unicode Text or even
HTML) and sometimes it doesn't (all the data gets pasted into column A and
not spread across columns).

I realize this might be a function of how the HTML is written on the web
site, but is there some conversion tool out there which will yield consistent
results?

Tx for your help and suggestions.

i'm a little behind you, so I'm not familiar with the importing wizards. how
do you use these functions?

I have been trying just to copy and paste special. perhaps importing and
using a wizard is more consistently successful, albeit avoiding the pitfall
you point out.

tx

"stebro" wrote:

I've had similar problems and learned that in my case this happened when I
had used the text-to-columns wizard in between times of importing data grids.
It's strange, but I had to make sure my most recent use of the wizard was as
"delimited by tabs option" then shut down Excel then go back in. Then try
your web query import again and it should work. Hope this helps...

steve

"Tenacity" wrote:

If there is a table of figures on a web site, is there a way to copy and
paste into Excel so the figures stay in the same columns as on the site, and
can be worked on as numbers within Excel.

Paste Special sometimes works (by pasting as Text, Unicode Text or even
HTML) and sometimes it doesn't (all the data gets pasted into column A and
not spread across columns).

I realize this might be a function of how the HTML is written on the web
site, but is there some conversion tool out there which will yield consistent
results?

Tx for your help and suggestions.