Copy a table from a web site, then manipulate the data?
I used a web sites drop down boxes to narrow down a product search. The
results of the search produced a table of values. I copied the table and pasted it into a spreadsheet, but what I expected to be values turned out to be a table with labels. (or numbers in "" quotes) Is there any easy way to convert the image to a table of values? |
Copy a table from a web site, then manipulate the data?
you should post your url for assistance. You probably would like to use an
external query to do this. With my xl2002 I can place my cursor on the tableright clickselect import to microsoft excel etc -- Don Guillett SalesAid Software "Confused Rookie" wrote in message ... I used a web sites drop down boxes to narrow down a product search. The results of the search produced a table of values. I copied the table and pasted it into a spreadsheet, but what I expected to be values turned out to be a table with labels. (or numbers in "" quotes) Is there any easy way to convert the image to a table of values? |
All times are GMT +1. The time now is 08:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com