- Sub t()
- Dim arr(), re(), i&, j As Byte, n$
- arr = Range("B2:B" & Cells(Rows.Count, 2).End(3).Row).Value
- ReDim re(1 To UBound(arr), 9)
- For i = 1 To UBound(arr)
- For j = 1 To Len(arr(i, 1))
- n = Mid(arr(i, 1), j, 1)
- re(i, n) = n
- Next
- Next
- Range("D2").Resize(UBound(arr), 10) = re
- End Sub
复制代码 |