excel中简单的提取数字和非数字
本帖最后由 erikafei 于 2019-4-25 17:15 编辑简单的提取数字和非数字
Function 提(Rg As Range, x)
Dim Reg
Set Reg = CreateObject("Vbscript.RegExp")
With Reg
.Global = True
If x = 1 Then
.Pattern = "\D"
Else
.Pattern = "\d"
End If
End With
提 = Reg.Replace(Rg, "")
End Function
谢谢分享 谢谢分享
页:
[1]