Split Function

Syntax:

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

Group:

Miscellaneous

Description: 

Returns a string array containing substrings from the original string.

Parameters:

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

Example:

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

See Also:

Join( )