title: Format part of a cell formula string as hyperlink
body: <p>Link to my dummy spreadsheet <a href="https://docs.google.com/spreadsheets/d/1luNznudza_bSYX4TbDyJ4AG6UtHL8T5YQ3l_aFvET9E/edit#gid=0" rel="nofollow noreferrer">here</a>.</p>
  
  <p>I need to partially format a cell by making a specific string set to a hyperlink found within another cell. I am currently nesting the hyperlink function within a <code>=REGEXREPLACE</code> function. Very messy and requires an extra cell. <strong>Example:</strong></p>
  
  <pre><code>=Regexreplace(B12,"Story Plan assignment", HYPERLINK(D12, "Story Plan Assignment"))
  </code></pre>
  
  <p>The above code is currently doing everything correctly, except that it replaces "Story Plan Assignment" from a different cell, but without carrying the hyperlink.</p>
  
  <p><strong>Here is what I actually want to do:</strong></p>
  
  <p><strong>Cell 1:</strong> string here, but find a word within the string and make that word have the hyperlink that is in cell 2<br>
  <strong>Cell 2:</strong> hyperlink</p>
  
  <p>If this can only be done populating a third cell, like I did with my first function, that's fine. Can I embed a function within a string"</p>