function like explode in vba code example

Example: vba split string

Dim names() As String
names = Split( "John Paul Smith" ,",")