va1damar Posted October 18, 2006 Posted October 18, 2006 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?
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now