Split String VBA based on value code example

Example: vba split string

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