title: Excel VBA Exclusion Words
body: <p>I have some exclusion words namely: Limited, Corporation, Incorporation, Inc, Ltd and Co in cells A2 to A6 respectively. </p>
  
  <p>In column B, it will be the input value of namely: ABC Limited, XYZ Holdings Corporation Limited and Tesco Bee Co Ltd in cells B2 to B4 respectively.</p>
  
  <p>In column C, it will display the results of B with the exclusion of any or all words from column A. It should show results of ABC, XYZ Holdings and Tesco Bee respectively. </p>
  
  <p>Will there be any formula or macros that will be able to solve this issue?</p>
  
  <p>I have attached a link to sample of what I am trying to illustrate. </p>
  
  <p><a href="https://i.stack.imgur.com/7PScq.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7PScq.jpg" alt="Screenshot here"></a></p>
  
  <p>I have tried this code: </p>
  
  <pre><code>Sub test()
      Dim OriginalText As String
      Dim CorrectedText As String 
      OriginalText = Range("C4").Value 
      CorrectedText = Replace(OriginalText, "Limited", "") 
      Range("C4").Offset(, 1).Value = CorrectedText 
  End Sub
  </code></pre>
  
  <p>However, I do not know how to incorporate all exclusion words in it, currently I managed to exclude "Limited" only.</p>