title: MS Excel: remove number of characters after a specific character in a string
body: <p>I have a column with values like </p>
  
  <blockquote>
    <p>WI60P-14E64F5167E6-01138</p>
  </blockquote>
  
  <p>or</p>
  
  <blockquote>
    <p>WI60-34D03E185267-01051</p>
  </blockquote>
  
  <p>etc....</p>
  
  <p>i need to find the first occurrence of <code>-</code> till the second occurrence of <code>-</code> and remove the resulting character.</p>
  
  <p>I am using this function <code>=MID(A1,FIND("-",A1),13)</code> which returns me <code>-34D03E185267</code> or <code>-14E64F5167E6</code> from the above strings.</p>
  
  <p>But I want the output like <strong>WI60P-01138</strong> or <strong>WI60-01051</strong></p>
  
  <p>Can anyone help me?</p>