title: How would I go about checking every cell in a column to see if it includes any text string in a cell from another column?
body: <p>I am working with a product database in Excel and seeking to clean up and homogenize the way to which manufacturers are referred. The database is about 9k rows so is not friendly to manual editing. There are also some manufacturer names missing in the database--it is not perfect.</p>
  
  <p>The headings for each column are organized as follows:</p>
  
  <pre><code>SKU(commercial product code)  |  Commercial Description  |  Manufacturer Name
  </code></pre>
  
  <p>And an example of a row entry would be:</p>
  
  <pre><code>MCO20264  |  PAD,BURNISH,27 IN,PK5  |  3M Corp.
  </code></pre>
  
  <p>The goal is to edit the Manufacturer Name column so that every time there is a reference to a manufacturer, for example 3M, whether it be by the entry 3M Corp., 3M Corporation, 3M, etc., it uses a homogeneous name, such as 3M, rather than multiple names. There are about 500 different Manufacturer Names. Many are referred to via multiple names, but when they are, they always include some abbreviated version of their name in the text string, like how 3M always appears in the list above.</p>
  
  <p>I already have some homogenized manufacturer names. The homogeneous manufacturer names that I have are in a column on a separate sheet, and because of how many there are I would like the cells in that column to be referenced rather than including individual text strings of each name in the function.</p>
  
  <p>I seek to exclude any row in my list of <strong>all</strong> manufacturers in which the Manufacturer Name cell contains a text string of a homogeneous name, such as 3M, anywhere in the cell, so that I can work with only those names which lack a homogeneous name to which they could be referred. The ultimate goal is to complete the homogeneous manufacturer names list, and apply it to the database so that each manufacturer is only referred to in one way.</p>
  
  <p>I have tried various ways to include</p>
  
  <pre><code>"*"A2"*"
  </code></pre>
  
  <p>type notation in functions to solve this issue, but have had no success including this notation here.</p>
  
  <p>Does anybody know how I could solve my problem?</p>