title: I want to take information from a google sheet cell and have it replace a part of a url that i'm pulling information from
body: <p>=SUBSTITUTE(index(IMPORTHTML(&quot;https://finviz.com/quote.ashxt=AAPL&quot;,&quot;table&quot;,8),9,4),&quot;*&quot;,&quot;&quot;)</p>
  <p>I want to take G2 (the tkr cell) and insert the ticker to replace the AAPL in the url.</p>
  <p><a href="https://i.stack.imgur.com/2O4ew.png" rel="nofollow noreferrer">https://i.stack.imgur.com/2O4ew.png</a></p>
  <p>Thank you if you can find a solution. I don't know how to articulate it well so if you need further clarification I can help.</p>