Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
Copy & Paste | Excel Discussion (Misc queries) | |||
copy paste cell character limit | Excel Discussion (Misc queries) |