|
自己想破了脑袋,也没有实现如图所示的效果啊,求大神解救,附件已上传了。。。。。实在没法了。
- Sub test3()
- Set regx = CreateObject("vbscript.regexp")
- rw = Cells(Rows.Count, 5).End(3).Row
- With regx
- .Global = True
- .Pattern = "\d+\-\d{1,}由.+"
- For Each RNG In Range("e2:e" & rw)
- Set mat = .Execute(RNG)
- For Each m In mat
- Cells(RNG.Row, "i") = m
- Next
- Next
- n = 0
- .Pattern = "\d+\-\d{1,}(?=由)"
- For Each RNG In Range("e2:e" & rw)
- Set mat = .Execute(RNG)
- For Each m In mat
- Cells(RNG.Row, "h") = m
- Next
- Next
- End With
- End Sub
复制代码
正则123.rar
(9.23 KB, 下载次数: 10)
|
|