title: Delete string from % in excel
body: <p>i have is 
    Excel book 1</p>
  
  <pre><code>    A
  13%38 vs 44
  13.64%38 vs 44
  7.66%239 vs 222
  </code></pre>
  
  <p>And i require is in same excel sheet:</p>
  
  <pre><code>         A                 B
      13%38 vs 44           13
      13.64%38 vs 44        13.64
      7.66%239 vs 222       7.66
  </code></pre>
  
  <p>So basically i need to remove everything after <code>%</code> in each cell.</p>
  
  <p>Can I achieve this with a formula in excel?</p>
  
  <p>Is it possible?</p>
  
  <p>Thanks</p>