title: Making links from script in google spreadsheet
body: <p>I want to make some links in my spreadsheet. I can make a string that looks like this. I looked around, though I did only find methods to link links that are already in the spreadsheet. </p>
  
  <pre><code>var linkBattlenet = "http://eu.battle.net/wow/en/character/"+toonrealm+"/"+toon.name+"/advanced"
  var showLink = "battle.net link"+toon.name //this is what shall be seen in the spreadsheet. 
  </code></pre>
  
  <p>I tried </p>
  
  <pre><code> var showLink = "battle.net link"+toon.name
   var linkBattlenet = showLink.link("http://eu.battle.net/wow/en/character/"+toonrealm+"/"+toon.name+"/advanced")
  </code></pre>
  
  <p>Here i got the problem that it printed a string into the spreadsheet cell, that looks like this: </p>
  
  <pre><code>&lt;a href="eu.battle.net---"&gt;"%Character name%" &lt;/a&gt;.  
  </code></pre>
  
  <p>(I am returnig the value in an array)</p>