View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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?