va1damar

When I use Data->Import External Data ->New Web Query I can select a block containing the text that I want (a price), but a lot of other stuff is often imported also. While I may recieve all of the following data: +--------+---------+ | Color: |BLACK | +--------+---------+ | Stock: |Available| +--------+---------+ | Price: |$439.00 | +--------+---------+ the only thing i want is the price $439.00. I want to insert that price (and nothing else) into specific cells in an existing spreadsheet that calculates price comparisons. Is there a way to parse out the cell containing $439.00 from everything that I get from the Web Query?

I work for a retail company that has several thousand spreadsheets they use to make price comparisons between their price and those of competitors. Right now they have to visit the competitor's web page and copy the price and past it into the spreadsheet. They do this for something in the order of 40,000 products (don't ask me why someone thought this was the way to approach the problem - i have no idea). I can write a perl script that goes out and grabs the price and returns it, but I don't know how to get the prices back into the excel spreadsheet. I don't have any restrictions on how I do this. My background is programming & I know very little about excel, so there may be a simple approach i'm just not familliar with. Thx all, va1damar