title: Excel: Value in one cell in another?
body: <p>I am looking for an excel formula to check to see if a value from one cell is in another.  I want to know if information from column A is found anywhere inside column B.  </p>
  
  <p>So since 123 Promotions is listed in A1 and also in B1, I want Excel to tell me its a match.</p>
  
  <p>Is there a way?</p>
  
  <p>Example:</p>
  
  <pre><code>Column A
  ABC Co/123 Promotions
  All About You, Inc
  Andrew Smith
  
  Column B
  123 Promotions
  All about You
  Smith Inc.
  </code></pre>