|
本帖最后由 wzsy2_mrf 于 2019-3-20 11:08 编辑
- Sub aa()
- Dim arr, i&, j&, k&, reg, brr(1 To 10000), trr
- Set reg = CreateObject("vbscript.regexp")
- reg.Pattern = "(([1-9]\d*\.?\d*)|(0\.\d*[1-9])|(采购)|(购买))" '必须外加括号
- reg.Global = True
- k = 1
- arr = Range("d2").CurrentRegion
- For i = 2 To UBound(arr)
- arr(i, 1) = reg.Replace(arr(i, 1), "$1元")
- trr = Split(arr(i, 1), "元")
- For j = 1 To UBound(trr)
- If trr(j) <> "" Then
- brr(k) = trr(0) & trr(j) & "元"
- k = k + 1
- End If
- Next
- Next
- Range("h3").Resize(k) = Application.WorksheetFunction.Transpose(brr)
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|