Split Function

Syntax

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

Group

Miscellaneous

Description

Return a string array containing substrings from the original string.

Parameters

Parameters 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.)

Example


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

See also

Join( )