Private Sub Command1_Click()
Dim lastReplaceStr As String
Dim curReplaceStr As String
Dim str() As String
Dim i As Long
curReplaceStr = "asd asdf gfdg sdfsdfsgsdg"
Do
curReplaceStr = Replace(curReplaceStr, " ", " ")
If lastReplaceStr = curReplaceStr Then
Exit Do
Else
lastReplaceStr = curReplaceStr
End If
Loop
str = Split(curReplaceStr, " ")
For i = LBound(str) To UBound(str)
Debug.Print str(i)
Next i
End Sub
Dim lastReplaceStr As String
Dim curReplaceStr As String
Dim str() As String
Dim i As Long
curReplaceStr = "asd asdf gfdg sdfsdfsgsdg"
Do
curReplaceStr = Replace(curReplaceStr, " ", " ")
If lastReplaceStr = curReplaceStr Then
Exit Do
Else
lastReplaceStr = curReplaceStr
End If
Loop
str = Split(curReplaceStr, " ")
For i = LBound(str) To UBound(str)
Debug.Print str(i)
Next i
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货