title: how can I format a cell in google spreadsheets
body: <p>I have a spreadsheet that have a column containing github issue numbers, how can I make all the fields in that column a url to the issue on github.<br>
  lets say <a href="https://github.com/myaccount/myrepo/issues/" rel="nofollow noreferrer">https://github.com/myaccount/myrepo/issues/</a> is where the issues exist, I want to make all those fields link to "<a href="https://github.com/myaccount/myrepo/issues/" rel="nofollow noreferrer">https://github.com/myaccount/myrepo/issues/</a>{existing-issue-nb-here}"</p>
  
  <h3>e.g: in line 54, column B(github issue #) should be a hyperlink to <a href="https://github.com/myaccount/myrepo/issues/652" rel="nofollow noreferrer">https://github.com/myaccount/myrepo/issues/652</a></h3>
  
  <p><a href="https://i.stack.imgur.com/MpgQY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MpgQY.png" alt="enter image description here"></a></p>