title: Excel: replace part of cell's string value
body: <p>I have a large spreadsheet with a column called "Roles". In this columns are values like:</p>
  
  <pre><code>ROLES
  Author
  Author;
  Publishing; Author;
  Something Else; Author; Publishing
  </code></pre>
  
  <p>There are other columns where the word "Author" may exist.</p>
  
  <p>What I need to do is look for "Author" in my "Roles" column only, and replace it with "Authoring", without losing anything before or after it. i.e. the end result should be:</p>
  
  <pre><code>ROLES
  Authoring
  Authoring;
  Publishing; Authoring;
  Something Else; Authoring; Publishing
  </code></pre>
  
  <p>I tried the <code>FIND</code>- and <code>REPLACE</code>-functions, but that replaced the entire cell value, not just a portion of it.</p>
  
  <pre><code>=IF(FIND("Author",[@Roles],1),REPLACE("Author",1,6,"Authoring"))
  </code></pre>
  
  <p>Can anyone help? I'd rather not us a VB solution, as I'm not familiar with how to do that, so hopefully there is a formula based way?</p>