第一次回帖,之前一直都是看和学习,只会用最笨的方法,还请大神们帮忙指出写的有问题的地方,持续学习中
Sub 拆分()
Dim i As Integer, j As Integer, n As Integer, str As String
ActiveSheet.Cells.NumberFormat = "@"
For n = 1 To Range("A1").End(xlDown).Row
j = 2
For i = 1 To Len(Cells(n, 1))
str = Mid(Cells(n, 1), i, 1)
If (Asc(str) >= 65 And Asc(str) <= 90) Or (Asc(str) >= 97 And Asc(str) <= 122) Or (IsNumeric(str) = True) Then
Cells(n, j) = Cells(n, j) & str
If Len(Cells(n, j)) = 3 Then
j = j + 1
End If
End If
Next