- Sub eksky()
- Dim ReGe As Object
- Dim Arr As Variant, MaR As Long, Brr As Variant
- Set ReGe = CreateObject("vbscript.regexp")
- Arr = Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row).Value
- ReDim Brr(1 To UBound(Arr), 1 To 1)
- With ReGe
- .Global = True
- .Pattern = "批发(\d+)"
- For MaR = 1 To UBound(Arr)
- If .test(Arr(MaR, 1)) Then
- Brr(MaR, 1) = .Execute(Arr(MaR, 1))(0).SubMatches(0)
- End If
- Next MaR
- End With
- Range("B1").Resize(UBound(Brr)) = Brr
- End Sub
复制代码 |