|
发表于 2014-7-6 13:08
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim i As Integer, j As Integer, k As Integer
- Dim ZF As String
- For i = 1 To Cells(Rows.Count, 2).End(3).Row
- For k = 1 To Len(Cells(i, 2))
- For j = 1 To 4
- ZF = ZF & j & Mid(Cells(i, 2), k, 1) & " "
- Next
- ZF = ZF & Mid(Cells(i, 2), k + 1, 1) & " "
-
- Next
- If Left(Cells(i, 2), 1) = "0" Then
- Cells(i, 3) = ZF
- Else
- Cells(i, 3) = Left(Cells(i, 2), 1) & " " & ZF
- End If
- ZF = ""
- Next
- End Sub
复制代码 试试吧
附件模拟结果放D列 对比 |
评分
-
查看全部评分
|