title: Extract an alphanumeric from sentence
body: <p>I would like to have an VBA to extract an alphanumeric value from a column G which is a sentence. </p>
  
  <p>This sentence is generally a comment. So it includes characters and numbers.  </p>
  
  <p>The value always starts with <code>AI0</code> and ends with <code>0</code>. This can be 11 to 13 digits long. Sometimes the number is mentioned in the comment as <code>AI038537500</code>, also sometimes as <code>AI038593790000</code>. </p>
  
  <p>I have researched through almost all the websites, but have not found any case like this. I know about the formulas, <code>left</code>, <code>right</code>, <code>mid</code> but in my case, it doesn't apply. </p>
  
  <p><a href="https://i.stack.imgur.com/vvIGv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vvIGv.png" alt="If you notice, here i have in comment section the Id with AI0 and Ends with 0. I want to extract this ID to result column.  "></a></p>
  
  <p>Any lead would be appreciable. </p>