Split Function

Syntax:

Split(Str, [Sep], [Max])

Group: Miscellaneous

Description:
Return a string array containing substrings from the original string.

Parameter Description

Str Extract substrings from this string value.

Sep Look for this string value to separate the substrings. (Default: " ")

Max Create at most this many substrings. (Default -1, which means create as many as are found.)

See Also: Join( ).

Example:

Sub Main
  Debug.Print Split("1 2 3")(1) '"2"
End Sub