Split Function
Syntax
Split(Str, [Sep], [Max])
Group
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