|
只做了分列,其他未考虑。
- Sub tt()
- arr = Range("a1:a" & [a65536].End(3).Row)
- ReDim brr(1 To UBound(arr) * 2, 1 To 2)
- With CreateObject("vbscript.regexp")
- .Global = True
- .Pattern = "\s\w+?\..+"
- For i = 1 To UBound(arr)
- x = arr(i, 1)
- If .test(x) Then
- n = n + 1
- brr(n, 1) = Trim(.Replace(x, ""))
- brr(n, 2) = Trim(.Execute(x)(0))
- Else
- brr(n, 2) = brr(n, 2) & " " & x
- End If
- Next
- End With
- [b1].Resize(n, 2) = brr
- End Sub
复制代码 |
|