copy and paste from the web without formatting

[Aaron]

I copy and paste chart data from web pages into excel.
Often the chart data contains extra formating that I do
not want: colored fonts, background shading, links to
other web pages, etc. I only want the actual text data
(the links to other web pages are esp. annoying).

To solve this problem, I do the following:

(1) copy from the web, paste in a worksheet
(2) copy the data in the work sheet, and "paste special-

values" to another worksheet

This is an annoying procedure to execute, as I do it
quite often. Is there a way to do this in a single step:
copy and paste data from a web page into excel WITHOUT
unwanted formatting?

thanks in advance,
Aaron

 

[Ken Wright]

Have you tried the following:-

With a worksheet open

Data / Import External Data / New Web Query / Click the arrow next to the table
you want and it will turn green

Then just hit 'Import Data', select where you want it to go and hit OK.

 

[Aaron]

Ken-

The web query function is great! (I was unaware of it
until now.)

Another question -- can I program a web query? For
example, if I want to query several similarly named web
pages, can I develop a formula to repeatedly query
several web pages of data into a single worksheet,
without manually inserting each one?

Thanks so much for your help!

-Aaron

 

[Ken Wright]

If I understand you correctly then yes, I think so. When you run through the
procedure and get to the last dialog box that says 'Import data', you can click
on the properties button and make various changes, one of which is to choose
regular updates, right down to every 60 seconds. You could do the Import query
a number of times and paste different tables into the same sheet or multiple
sheets and then have each of them update as per your specs (I believe - haven't
tried it).