title: Finding punctuation within VBA string from the right side
body: <p>In VBA, how do I find the first instance of a punctuation symbol, from the right hand side? For example, from "!", I should be able to get the term "Security" two times in the following string:</p>
  
  <pre><code>INDEX(Security![a range], MATCH(J2,Security![a range],0))
  </code></pre>
  
  <p>Something like InStrRev would be ideal but seems like it doesnt support regex expressions. Any help is greatly appreciated!</p>