title: Delete Certain Characters in Excel 2010
body: <p>I have ~4000 records of data in Excel 2010 that as below:</p>
  
  <pre><code>QW3-WE-2232-322-A-2
  WETE-33-3REE-33-WEWE-3
  DEE-3YED-3432-DXSDDD-3FESE-2
  343-34SE-34323-AWBE-3
  ABDC-343-3THYT-2
  </code></pre>
  
  <p>I want the data to look like this where everything after the last dash is deleted.</p>
  
  <pre><code>QW3-WE-2232-322-A
  WETE-33-3REE-33-WEWE
  DEE-3YED-3432-DXSDDD-3FESE
  343-34SE-34323-AWBE
  ABDC-343-3THYT
  </code></pre>
  
  <p>Was wondering if there was an easy way to do this Excel?</p>