title: Autocorrecting text entries based on predefined list
body: <p>Problem is simple: I'm copying or typing in company names which need to be formatted in a certain way. For example, column one is:</p>
  
  <pre><code>A.G. Edwards Inc., New York 
  Abbott Laboratories L.T.D., Los Angeles
  Abercrombie &amp; Fitch Co., Mars
  ABM Industries Incorporated L.T.D., Venus
  </code></pre>
  
  <p>but the data which I receive is:</p>
  
  <pre><code>A.G. Edwards
  Abbott Laboratories. 
  Abercrombie &amp; Fitch 
  ABM Industries Incorporated. 
  </code></pre>
  
  <p>What I'm looking for is a way to automate formatting by using predefined proper list which would be in another workbook or access database. </p>
  
  <p>So when I type Abbot Laboratories it would autocorrect to proper format, or whats more often when I paste ABOTT LABORATORIES it would correct it.</p>
  
  <ul>
  <li>I'm not sure if autocorrect could do this because list would be really long 600+ entries, plus not always my input data is the same (sometimes I get Abbot Laboratories LTD, sometimes its Abbot Laboratories, los angeles), name is usually correct but rest changes.</li>
  </ul>
  
  <p>I've googled extensively but nothing I found so far looks like it would help me.</p>
  
  <p>So to recap: check text in one column and correct it to match large list of proper text entries.</p>
  
  <p>Thanks in advance.</p>