Sub test()
Dim A, B(1 To 10 ^ 5, 1 To 2), i, j, s
Application.DisplayAlerts = False
With Sheets(2)
'1)将数据源第2列按逗号分列
i = Sheets(1).Cells(Rows.Count, 1).End(xlUp).Row
Sheets(1).Range("a1:b" & i).Copy .Range("a1")
.Cells.NumberFormat = "000000000000"
.Range("b:b").TextToColumns Comma:=True
A = .Range("a1").CurrentRegion
'2)存入数组B
For i = 2 To UBound(A)
For j = 2 To UBound(A, 2)
If A(i, j) = "" Then
Exit For
Else
s = s + 1: B(s, 1) = A(i, 1): B(s, 2) = A(i, j)
End If
Next j
Next i
'3)输出
.Range("a1").CurrentRegion = ""
.Range("a1").Resize(s, 2) = B
.Columns(2).AutoFit
.Activate
End With
End Sub
快递单号2.rar
(362.35 KB, 下载次数: 16)