title: Macro loop for deleting unwanted characters from cells
body: <p>I have data in columns A and B. I need a macro that will loop through these columns and delete the text at the end. The columns look like this:</p>
  
  <pre><code>Column A    Column B
  1234(AZ)    X1258Q156(ABCD)
  3259(AZ)    81R58Q1V6(ABCD)
  7849(AZ)    X1X58-156(ABCD)
  1489(AZ)    XX258Q1(ABCD)
  </code></pre>
  
  <p>I need the macro to loop through column A and column B and remove the characters at the end. In column A's example, remove all (AZ) from it and in column B's example remove all (ABCD) from it. The text length will vary in column A and column B. Thank you.</p>