title: Excel formula to compare partial match cells
body: <p>I am looking for help with a formula.  </p>
  
  <p>I need to compare text in two cells (not columns).  </p>
  
  <p>One of the cells has a last name, the other cell may have part of the last name with additional numbers and letters (not in any specific order). These are the pairs we would like to locate.  </p>
  
  <p>Not all of the cells will match, however for the ones where part of the text matches, would like something like <code>"MATCH"</code>. </p>
  
  <p>For example in cell <code>E2= 000034568MILL WALLI</code> and in cell <code>J2=WALLINGER</code> should bring a  <code>MATCH</code>, since the <code>WALLI</code> in cell <code>E2</code> matches part of the text.</p>
  
  <p>Another example:</p>
  
  <p><code>E2= Benjamin P Rouamba</code> and <code>J2=Roumbamoore</code> should bring back match.</p>
  
  <p>I hope this makes sense and that there is a possible formula for this.</p>