Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
data table based on data table | Excel Discussion (Misc queries) | |||
Copy table from web site | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Sort pages? | Excel Discussion (Misc queries) |