title: Converting letters to numbers in VBA
body: <p>Looking for some suggestions. I have cell values with a combination of letters and numbers in a cell. Each value is 6 letters, followed by 0000 followed by 4 letters and then between 5 and 8 numbers. E.G. </p>
  
  <pre><code>IIKBAR0000EEEE510002
  MQYUQF0000EEEE410003
  MWWVIQ0000ZYXW210004
  DJHZXL0000BBBB410005
  </code></pre>
  
  <p>These are more or less completely random, and there are between 100k and 1,048,576 of them!</p>
  
  <p>Is there any way that I can convert the letters into a number (I.e. A = 1, B = 2, Z = 26, etc.) without having to tell VBA the value of each letter? the code I am currently using is quite slow as it has 26 If-Else cases.</p>