|
发表于 2017-4-24 09:59
|
显示全部楼层
本楼为最佳答案
- Sub tt()
- arr = Range("a1:a" & [a65536].End(3).Row)
- ReDim brr(1 To 2 * UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- If InStr(arr(i, 1), "G85") = 0 Then
- n = n + 1
- brr(n, 1) = arr(i, 1)
- Else
- xrr = Split(arr(i, 1), "G85")
- For k = 0 To 1
- x = xrr(k): p = Len(Replace(x, "-", ""))
- If p < 14 Then x = x & Application.WorksheetFunction.Rept("0", 14 - p) '不满14位的,用0补足
- n = n + 1
- brr(n, 1) = x
- Next
- End If
- Next
- [s1].Resize(n, 1) = brr
- End Sub
复制代码 |
|