RegEx in excel

regex_in_excel.vbs

'Turn on developer bar
'Add Extension "Microsoft vbscript regex 5.5"
' - Select "Developer" tab (I don't have this tab what do I do?)
' - Select "Visual Basic" icon from 'Code' ribbon section
' - In "Microsoft Visual Basic for Applications" window select "Tools" from the top menu.
' - Select "References"
' - Check the box next to "Microsoft VBScript Regular Expressions 5.5" to include in your workbook.
' - Click "OK"

Public Function RegexExtract(ByVal text As String, ByVal expr As String)

    Dim regEx As New RegExp
    Dim capture As String
    
    With regEx
        .Global = False
        .MultiLine = False
        .IgnoreCase = False
        .Pattern = expr
        
        If .Test(text) Then
            capture = .Execute(text)(0)
            RegexExtract = .Replace(capture, "$1")
        Else
            RegexExtract = ""
        End If
        
    End With
    
End Function