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
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now