凑合着用吧- Sub demo()
- Dim SplitStr$, arr(1 To 100000, 1 To 1)
- SplitStr = Range("G3").Value
- With CreateObject("VBScript.RegExp")
- .Global = True
- .MultiLine = True
- .Pattern = "\s\d+"
- For Each imat In .Execute(SplitStr)
- i = i + 1
- arr(i, 1) = Mid(imat, 2, Len(imat) - 1)
- Next
- End With
- Range("H3").Resize(i, 1).NumberFormatLocal = "@"
- Range("H3").Resize(i, 1) = arr
- End Sub
复制代码 |