title: Extracting lookup_value from VLOOKUP formula on MacOS
body: <p>On Windows I used the following function to extract the <code>lookup_value</code> from a <code>VLOOKUP</code> formula. However, I recently switched to macOS and the function is now incompatible.</p>
  
  <p>VBA in Excel on Mac does not support regular expressions. Is there any alternative function I could use or am I out of luck?</p>
  
  <pre><code>Function extractFirstInt(strValue As String) As Integer
      Dim regex As New regexp
      regex.Pattern = "(\d+)"
      extractFirstInt = regex.Execute(strValue)(0).SubMatches(0)
  End Function
  </code></pre>