split function vba example

Example: vba split string

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