title: Excel VBA - Take only the numeric value in a cell
body: <p>I have an IF function in VBA that has a mathematical formula in it:- <code>(Cells(i3, 10).Value &gt; 30)</code></p>
  
  <p>The issue i'm having is that the values in column 10 are all alphanumeric. For example they're all " 1 - Hard", "2 - Moderate", "3 - Easy". </p>
  
  <p>Is there anyway to make VBA only look at the number so when it's testing if the value is more than 30, it actually works?</p>
  
  <p>Thanks</p>