title: Excel replace only exact text
body: <p>Is it possible to build a formula in MS excel that would replace only exact word? For example:</p>
  
  <p><strong>My apple is red</strong>. I want to replace red with green, so it goes <strong>My apple is green</strong>.</p>
  
  <p>I know I can use =replace</p>
  
  <p>But if my sentence is: <strong>My apple is reddish</strong>. The formula should ignore and not replace red part.</p>
  
  <p>I was thinking to use this combination " "&amp;"red"&amp;" " so it would change only if there is space before or after.But for some reason I can't make it work.</p>
  
  <p>Edit:
  This what I have</p>
  
  <p><a href="https://i.stack.imgur.com/aF1vD.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aF1vD.jpg" alt="enter image description here"></a></p>
  
  <p>=REPLACE(A1,SEARCH(" "&amp;E1,A1),LEN(E1)+1," "&amp;E1)</p>
  
  <p>If I add &amp;" " after E1 it will break, because there is no space left.</p>