Private Sub Command1_Click()
Dim arrTemp
Dim strTemp As String
Dim i As Integer
Dim j As Integer
Dim test(7) As String
strTemp = "1 周 管理科 男 科长 1000 3000 4000"
arrTemp = Split(strTemp, " ")
For i = LBound(arrTemp) To UBound(arrTemp)
If Trim(arrTemp(i)) <> "" Then
test(j) = arrTemp(i)
j = j + 1
End If
Next