Web Query - Change a word in query to form a new query

[scottymelloty]

Hi

I want to set up a Web Query that is set in cell A1
the URL will have somewhere in the url the word top

I then want the sheet to automatically bring in the same URL into another cell say G1 but in the url will search the url for the word "top" and change that to the word "left" and bring in that URL data

Then in Cell I1 the exact same same URL from Cell A1 but this time swapping the word top for right

so i am only setting up one URL web query in A1 and then G1 an I1 are auto generating a new url from that original URL and swapping a word in them

is that possible ?

many thanks in advance

[scottymelloty]

or could i put the url link into a cell and a web query through a macro and button when pressed pinks up that link from the cell value?