How to split string using vba

 Please paste these lines in VBA macro.

Dim Team As String
Dim LArray() As String

Team = "Others Others Others Others"
LArray() = Split(Team, " ") Or
LArray() = Split(Team) ' enough for space , if any other delimitter, please use above syntax