Cleaning up a web query

[Jim]

I'm bringing in some tables from a web page. The cell contents I want
to keep are those that have text that is hyperlinked. There are other
cells that are a hyperlink only (no text) or text only that I want to
clear. What approach should I take? I'm thinking I can loop through
the range, but I'm never worked with this type of data and don't know
how to specify the conditions for clearing the unwanted cells.
TIA,
Jim

 

[Don Guillett]

What is often done is to just use a macro or formulas to get what you need
from the sheet where the web page was brought in to the sheet where it is
needed. More info and a url might be helpful.

 

[Jim]

A typical page I'm pulling in is
http://www.llbean.com/webapp/wcs/st...529&storeId=1&catalogId=1&langId=-1&feat=dp26.

From this, I pull in tables 11,12,13,14 with full HTML formatting.

The only cells I'm interested in keeping the contents of are the text
hyperlink cells. I use a custom function to extract the URL from the
hyperlink into a cell above it, from which I use a MID function to get
a product ID into a cell above it also that I can then do vlookups off
of to pull in the data I want displayed.

But you'll notice that there is a cell where the webpage image is that
just holds a hyperlink, as well as the price text, that I'd like
cleared. I've noticed in pulling in different pages that these aren't
always on the same row, so I can't do a shortcut that way.

Thanks again,
Jim

 

[Don Guillett]

If you want to send me the workbook with a description(BY CELL ADDRESS) what
you want, I will take a look.