|
水木 发表于 2014-10-14 13:20
要求是以后1、2、3、4、5、6、7、8、9、10、11……/,为一段,以“1、”为一字符,但文中若有“、”号的句 ... - Sub demo()
- Dim arr, brr(), i As Long, j As Long, n As Long
- arr = Sheets("原数据").Range("a2:f" & Sheets("原数据").Cells(Rows.Count, 1).End(xlUp).Row)
- ReDim brr(1 To 1000, 1 To 7)
- For i = 1 To UBound(arr)
- crr = Split(arr(i, 6), "/")
- For j = 0 To UBound(crr) - 1
- n = n + 1
- brr(n, 1) = arr(i, 1)
- brr(n, 2) = arr(i, 2)
- brr(n, 3) = arr(i, 3)
- brr(n, 4) = arr(i, 4)
- brr(n, 5) = arr(i, 5)
- brr(n, 6) = Split(Replace(crr(j), "、", "-", , 1), "-")(0)
- brr(n, 7) = Split(Replace(crr(j), "、", "-", , 1), "-")(1)
- Next
- Next
- Sheets("重排").Range("a2").Resize(n, 7) = brr
- End Sub
复制代码 这样试试
|
评分
-
查看全部评分
|