title: EXCEL: Find and Replace, Change Entire Cell Value
body: <p>I want to :</p>
  
  <ol>
  <li>Search if cell contains a certain text (like "orange" in "orange crush")</li>
  <li>If return true, change entire cell value to "orange"</li>
  </ol>
  
  <p>Up until now, I can search for the cell, and change the specific text to something I want, but not the entire cell (like "orange" to "blue" and have it be "blue crush", which isn't what I want to do. I want it just to be "blue"). I've been doing this with the "find &amp; replace" function.</p>
  
  <p>I've also used the function </p>
  
  <pre><code>=if(isnumber(search("orange",B2)), substitute(B2, B2, "orange"), B2)
  </code></pre>
  
  <p>which works!, but prints in the new column I wrote the code, and doesn't replace the value in B2 where it's referencing. </p>
  
  <p>Possibly done in VBA?</p>
  
  <p>What I have:</p>
  
  <pre><code>Oranges
  Orange slices
  Orange
  Orange pulp
  </code></pre>
  
  <p>What I want:</p>
  
  <pre><code>Orange
  Orange
  Orange
  Orange
  </code></pre>