Split Function

Syntax

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

Group

Miscellaneous

Description

Returns a string array containing substrings from the original string.

Parameters

Parameters	Description
Str	Extracts substrings from this string value.
Sep	Looks for this string value to separate the substrings. (Default: " ")
Max	Creates 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( )