level 1
代码如下:
Private Sub CommandButton1_Click()
Dim MYT As String
HH = 2
Do While Cells(HH, 2) <> ""
MYT = Cells(HH, 2).Text
Cells(HH, 3) = MYF(MYT)
HH = HH + 1
Loop
End Sub
Function MYF(S As String) As String
MYF = ""
ARR = Split(S, Chr(10))
For I = 0 To UBound(ARR)
MYF = MYF & Int(Val(ARR(I))) & Chr(10) & Chr(13)
Next I
End Function
效果如图:



