title: Delete last string suffix vba
body: <p>I'm wondering if there is a way more efficient approach in deleting the last string value in a cell value.</p>
  
  <p>In my case I need to delete a suffix i.e </p>
  
  <pre><code>TNV1602000014C      //delete suffix C 
  117239B             //delete suffix B
  MRV117299           //nothing to delete
  115365Z             //delete suffix Z        
  </code></pre>
  
  <p>I've tried this approach </p>
  
  <pre><code>lastrow = Cells(Rows.Count, "C").End(xlUp).Row  
  Range("E2:E" &amp; lastrow).Formula = "=TRIM(RIGHT(SUBSTITUTE(RC[-1],""A"",REPT("""",LEN(RC[-1]))),LEN(RC[-1])))"
  </code></pre>
  
  <p>but since I need to do this for the whole A-Z.
  is there any way?</p>