title: "=Search()" function giving inconsisten results
body: <p>I have this formula:</p>
  
  <pre><code>=IF(ISERR(SEARCH(" ?/?/????",C7)=11)=FALSE,"0"&amp;MID(C7,12,2)&amp;"0"&amp;MID(C7,14,6),
  IF(ISERR(SEARCH(" ?/??/????",D7)=11)=FALSE,"0"&amp;MID(D7,12,9),
  IF(ISERR(SEARCH(" ??/?/????",D7)=11)=FALSE,MID(D7,12,3)&amp;"0"&amp;MID(D7,15,6),
  IF(ISERR(SEARCH(" ??/??/????",D7)=11)=FALSE,MID(D7,12,9),1))))
  </code></pre>
  
  <p>On this cell:
      Completed: 2/22/2017 Status: Completed</p>
  
  <p>it returns 02/22/2017 which is correct</p>
  
  <p>On this cell, copied from another program, 
      Completed: 2/22/2017 Status: Completed
  It returns 1.   </p>
  
  <p>I can't see any difference in the two lines but apparently the formula sees a difference. Let's say the text is in cells A1 and A2.  If in cell A3 I do A1=A2 I get False.  I cannot see the difference.  I even did =trim(clean( . . on both cells but no joy</p>