|
比如一列中有如下数据,有什么好方法可以将其中的手机号码提取出来
85827582/13507431512 | 85681238/85659298 | 85601270/13787311981 | 85501886/13786104289 | 85499766;86823528 | 85456213 88982552 | 85226837/15116381133 | 85190711;85458085 | 85136972/ 82613776 | 8496183-8202 | 84835919/84835750 | 84710528。82733938 | 8450047 13687371306 | 83111587/013867926705 | 82780024/8278037213974867861(代) | 13974867808(代) | 13974836734曹 |
|
- Sub Test()
- Dim Regex As Object
- Dim Str As String
- Dim arr()
- Dim i As Integer
-
- arr = Range("a1:a" & Range("a65536").End(xlUp).Row).Value
- Set Regex = CreateObject("VBScript.RegExp")
- For i = 1 To UBound(arr)
- With Regex
- .Pattern = "\d{11,12}"
- If .Execute(arr(i, 1)).Count > 0 Then
- arr(i, 1) = .Execute(arr(i, 1))(0)
- Else
- arr(i, 1) = ""
- End If
- End With
- Next i
- Columns(2).ClearContents
- Columns(2).NumberFormat = "@"
- Range("B1").Resize(UBound(arr), 1) = arr
- End Sub
复制代码
工作簿1.rar
(10.73 KB, 下载次数: 5)
|
|