Private Sub Command1_Click() Dim str As String, i As Integer, s() As String str = "ab+bc-ds*eq/bp(aa+mp)" For i = 1 To Len(str) Select Case Mid(str, i, 1) Case "+", "-", "*", "/", "(", ")" Mid(str, i, 1) = " " End Select Next i s = Split(str) For i = 0 To UBound(s) Debug.Print s(i) Next i End Sub
Dim a As String Dim b() As String a = "ab+bc-ds*eq/bp(aa+mp)"a = Replace(a, "+", ",") a = Replace(a, "-", ",") a = Replace(a, "*", ",") a = Replace(a, "/", ",") a = Replace(a, "(", ",") a = Replace(a, ")", ",")b = Split(a, ",") Dim i As Integer For i = LBound(b) To UBound(b) Debug.Print (b(i)) Next
Dim str As String, i As Integer, s() As String
str = "ab+bc-ds*eq/bp(aa+mp)"
For i = 1 To Len(str)
Select Case Mid(str, i, 1)
Case "+", "-", "*", "/", "(", ")"
Mid(str, i, 1) = " "
End Select
Next i
s = Split(str)
For i = 0 To UBound(s)
Debug.Print s(i)
Next i
End Sub
Dim b() As String
a = "ab+bc-ds*eq/bp(aa+mp)"a = Replace(a, "+", ",")
a = Replace(a, "-", ",")
a = Replace(a, "*", ",")
a = Replace(a, "/", ",")
a = Replace(a, "(", ",")
a = Replace(a, ")", ",")b = Split(a, ",")
Dim i As Integer
For i = LBound(b) To UBound(b)
Debug.Print (b(i))
Next