|
本帖最后由 7171 于 2016-12-19 17:05 编辑
Sub test()
Dim arr()
Dim arr1()
Dim arr2()
Dim arr3() As String
Dim arr4() As String
arr1 = Range("a2:a7")
arr2 = Range("b2:b7")
ReDim arr(1 To UBound(arr1))
For i = 1 To UBound(arr1)
arr3 = Split(arr1(i, 1), Chr(10))
arr4 = Split(arr2(i, 1), Chr(10))
For j = 0 To UBound(arr4)
arr4(j) = Join(Array("(", arr4(j), ")"), "")
arr3(j) = Join(Array(arr3(j), arr4(j)), "")
Next
arr(i) = Join(arr3, Chr(10))
Next
Range("c2:c7") = Application.WorksheetFunction.Transpose(arr)
End Sub
这是我的方法,请高手指教
|
评分
-
查看全部评分
|