Sub test()
Dim myreg
Dim arr, brr(1 To 10000, 1 To 1)
arr = Range("A1").CurrentRegion
Set myreg = CreateObject("VBSCRIPT.REGEXP")
For i = 2 To UBound(arr)
With myreg
.Pattern = "\b[a-zA-Z]+"
.Global = True
brr(i - 1, 1) = .Execute(arr(i, 1))(0)
End With
Next
Range("C2").Resize(i) = brr
End Sub