vba explode string to array code example

Example: vba split string

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