|
发表于 2021-11-23 00:16
|
显示全部楼层
本楼为最佳答案
- Sub 拆分()
- Dim ARR1, ARR2(), I As Integer, J As Integer, ARR3()
- ARR1 = Split(Range("C2"), "(")
- I = UBound(ARR1)
- ReDim ARR2(1 To I)
- For J = 1 To I
- ARR2(J) = Mid(ARR1(J), 1, InStr(ARR1(J), ")") - 1)
- Next
- Range("d2").Resize(1, J - 1) = ARR2
- ARR1 = Split(Range("b3"), "(")
- I = UBound(ARR1)
- ReDim ARR3(1 To I)
- For J = 1 To I
- ARR3(J) = Mid(ARR1(J), 1, InStr(ARR1(J), ")") - 1)
- Next
- Range("b4").Resize(J - 1, 1) = Application.Transpose(ARR3)
- End Sub
复制代码
|
|