title: Insert Dynamic Value in URL from a Cell in Google Sheet
body: <p>I am trying to build a URL in a cell (google sheets) which will get some of its values from different cells. I have tried using all different ways I can think of like concatenate, Join, &amp; etc but the problem is that the URL has some curly brackets and &quot; as a requirement and that breaks the formula:</p>
  <p>URL Example
  <a href="https://katang.io/?t_pid=1&amp;t_extra=%7B%22Source%22:%22stackoverflow%22,%22Type%22:%22email%22,%22Stategy%22:%22banner%22%7D" rel="nofollow noreferrer">https://katang.io/?t_pid=1&amp;t_extra={&quot;Source&quot;:&quot;stackoverflow&quot;,&quot;Type&quot;:&quot;email&quot;,&quot;Stategy&quot;:&quot;banner&quot;}</a></p>
  <p>So I need &quot;Source&quot;:&quot;<strong>stackoverflow</strong>&quot; to be dynamic</p>
  <p>so for example &quot;Source&quot;:&quot;<strong>Get Value from Cell A1</strong>&quot;</p>
  <p>Any Help or guidance will be much appreciated</p>