Split Function
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Description
Returns a zero-based, one-dimensional array containing a specified number of substrings.
Syntax
Split(expression[, delimiter[, limit[, compare]]])
The Split function syntax has these named arguments:
Part |
Description |
|---|---|
expression |
Required. String expression containing substrings and delimiters. If expression is a zero-length string(""), Split returns an empty array, that is, an array with no elements and no data. |
delimiter |
Optional. String character used to identify substring limits. If omitted, the space character (" ") is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire expression string is returned. |
limit |
Optional. Number of substrings to be returned; –1 indicates that all substrings are returned. |
compare |
Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values. |
Settings
The compare argument can have the following values:
Constant |
Value |
Description |
|---|---|---|
vbUseCompareOption |
–1 |
Performs a comparison using the setting of the Option Compare statement. |
vbBinaryCompare |
0 |
Performs a binary comparison. |
vbTextCompare |
1 |
Performs a textual comparison. |
vbDatabaseCompare |
2 |
Microsoft Access only. Performs a comparison based on information in your database. |