Reg Expression

[Middlemarch]

I want to get just a-z from a string and using this

Function AlphaOnly(Inval) As String
    Dim re As Object, REMatches As Object
    Set re = CreateObject("vbscript.regexp")
    re.Pattern = "\D+"
    If (re.Test(Inval) = True) Then
        Set REMatches = re.Execute(Inval)
        AlphaOnly = REMatches(0)
    End If
    Set REMatches = Nothing
    Set re = Nothing
End Function

Maybe that's overkill and there's a better method ?
But also a bit intrigued, if inVal contains () why is the opening bracket also returned.

[June7]

Please provide sample data and desired result.

Appears to return anything that is not a number.

Review https://www.appsloveworld.com/vba/20...numeric-string

[Middlemarch]

It could be "001xx(99)"
You want just "xx" but get "xx("

[June7]

Did you review article from link in post 2?

Try pattern "[a-zA-Z]+"

[Middlemarch]

Thank you, sorted.