title: Most efficient VBA code to convert string variable to integer
body: <p>I have the following code that converts a string of the following format:<br>
  <code>"G##"</code> to an integer <code>##</code></p>
  
  <pre><code>Dim str As String
  Dim int As Integer
  str = "G14"
  int = CInt(Right(str, Len(str) - 1))
  </code></pre>
  
  <p>But this is going to be run on a large database regularly.</p>
  
  <p>I am wondering if there are any alternatives that may be more efficient (especially in regards to the last line)?</p>