Private Sub test1()
Dim Str As String, Arry
Str = "11111 2222 3333 0 0.001 1 2"
'用正则表达式来分割每个字符段,保证中间无论有多少空格都不会影响判断。
With CreateObject("vbscript.regexp")
.Global = True
.Pattern = "\s+"
Str = .Replace(Str, "*")
End With
Arry = Split(Str, "*") '产生一维数组变量。
End Sub