|
发表于 2012-8-21 23:33
|
显示全部楼层
本楼为最佳答案
本帖最后由 柳如烟 于 2012-8-21 23:35 编辑
- Sub 拆分单元格内数据()
- Dim arr, brr(1 To 10000, 1 To 4), a
- Dim i%, j%, k%, m%, n%, s$, str$
- arr = Range("a2:d" & Range("a65536").End(3).Row)
- For i = 1 To UBound(arr)
- a = Split(arr(i, 1), "/")
- For j = 0 To UBound(a)
- For m = 1 To Len(a(j))
- If IsNumeric(Mid(a(j), m, 1)) Then
- n = Mid(a(j), m)
- s = Left(a(j), m - 1)
- Exit For
- End If
- Next
- For m = 1 To Len(s) Step 2
- str = Mid(s, m, 2)
- k = k + 1
- brr(k, 1) = str & n
- brr(k, 2) = arr(i, 2)
- brr(k, 3) = arr(i, 3)
- brr(k, 4) = arr(i, 4)
- Next
- Next
- Next
- With Range("e2").Resize(k, 4)
- .ClearContents
- .Value = brr
- End With
- End Sub
复制代码 看着你的结果写的。
|
|