第一个参数为要提取数据的单元格,第二个参数为要提取的类型:1-中文,2-英文字母,3-数字。
- Function zh(rag As Range, lx As Integer)
- Dim reg As Object
- Set reg = CreateObject("vbscript.regexp")
- tj = Choose(lx, "\w", "[^a-zA-Z]", "\D")
- With reg
- .Global = True
- .Pattern = tj
- zh = .Replace(rag, "")
- End With
- End Function
复制代码
或用下面的自定义函数也可以:
- Function MyGet(Srg As String, Optional n As Integer = False)
-
- Dim i As Integer
- Dim s, MyString As String
- Dim Bol As Boolean
-
- For i = 1 To Len(Srg)
- s = Mid(Srg, i, 1)
- If n = 1 Then
- Bol = Asc(s) < 0
- ElseIf n = 2 Then
- Bol = s Like "[a-z,A-Z]"
- ElseIf n = 0 Then
- Bol = s Like "#"
- End If
- If Bol Then MyString = MyString & s
- Next
-
- MyGet = IIf(n = 1 Or n = 2, MyString, Val(MyString))
-
- End Function
复制代码 |