Sub TEST()
Dim Arr(1 To 20000, 0), A, B, C, i&, N&, T$, TR
For Each A In Range([A2], [A65536].End(xlUp))
For Each B In Split(A, Chr(10))
T = Left(B, 8): TR = Split(Mid(B, 9), "~")
For i = Mid(TR(0), 2) To Mid(TR(1), 2)
N = N + 1: Arr(N, 0) = T & Left(TR(0), 1) & i
Next
Next: Next
[F3].Resize(N) = Arr
End Sub作者: fantersy 時間: 2018-10-18 20:37
Sub TEST1()
Dim Arr(1 To 20000, 1), A, B, C, W&, D$, i&, N&, T$, TR
For Each A In Range([H2], [H65536].End(xlUp))
W = W + 1: D = Cells(W + 1, 2)
For Each B In Split(A, Chr(10))
T = Left(B, 8): TR = Split(Mid(B, 9) & "~" & Mid(B, 9), "~")
For i = Mid(TR(0), 2) To Mid(TR(1), 2)
N = N + 1: Arr(N, 0) = D: Arr(N, 1) = T & Left(TR(0), 1) & i
Next
Next: Next
[J:K].ClearContents
[J3:K3].Resize(N) = Arr
End Sub