split-function.md

title	keywords	f1_keywords	ms.prod	ms.assetid	ms.date
Split Function	vblr6.chm1008907	vblr6.chm1008907	office	7c68f50a-c4c4-ee16-cc04-9d067a0b5819	06/08/2017

Split Function

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