title: Extract Character from Filename with RegEx in Excel VBA
body: <p>My strings are filenames like this:</p>
  
  <ul>
  <li><p>Filename 1 (A12 V1.1)</p></li>
  <li><p>Filename 1 (V2) Text (A9 V2.3 8.99)</p></li>
  <li><p>Filename V2 Text (A34 8.3 V4)</p></li>
  </ul>
  
  <p>How do I extract only the numbers which start with the 'V', contained within the last brackets only, and excluding the 'V'?</p>
  
  <p>i.e. - 1.1, 2.3, 4</p>
  
  <p>The following Regex UDF was provided by YasserKhalil (<a href="https://stackoverflow.com/questions/56099989/extract-last-bracketed-characters-from-string-in-excel-vba/56100247?noredirect=1#comment98850580_56100247">Previous Post Here)</a></p>
  
  <p>However, the UDF is returning on filenames like: </p>
  
  <ul>
  <li><p>IPV32_20.dll which returns V32-20 </p></li>
  <li><p>IMV1.dll which returns V1.</p></li>
  </ul>
  
  <p>These filenames do not contain brackets, so they should not be returning anything.</p>
  
  <p>How to modify this UDF?</p>