ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copy a table from a web site, then manipulate the data? (https://www.excelbanter.com/excel-worksheet-functions/115724-copy-table-web-site-then-manipulate-data.html)

Confused Rookie

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?

Don Guillett

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