title: How can I create a hyperlink in the middle of cell text?
body: <p>In google spreadsheets, it is possible to add a hyperlink to a cell as:</p>
  <pre><code> =hyperlink(&quot;www.google.com&quot;, &quot;search the web&quot;)
  </code></pre>
  <p>This will show the text search the web which will hyperlink to google.  However, I am wondering:</p>
  <p>How can this rule be inserting into the middle of a cell?  In other words, I'd like a single cell to look like:</p>
  <blockquote>
  <p>click <a href="http://www.google.com" rel="nofollow noreferrer">here</a> for answer</p>
  </blockquote>