split string in excel using vb.net code example

Example: vba split string

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