Sub Click()
Dim A, B, i, j
A = Range("b2:f" & [b65536].End(3).Row)
B = Array(0, 2, 4, 6, 8, 0, 2, 4, 6, 8)
For i = 1 To UBound(A)
For j = 1 To 3
A(i, j + 1) = Mid(A(i, 1), j, 1)
Next j
A(i, 5) = B(A(i, 2)) & B(A(i, 3)) & B(A(i, 4))
Next i
[b2].Resize(UBound(A), UBound(A, 2)) = A
End Sub
1.rar
(15.82 KB, 下载次数: 11)