Excel VBA Split Function: The Split function in VBA is used to split a string into several substrings and return a one-dimensional array of substrings.

Syntax

Parameter

Expression (required) – This parameter represents a text string that you want to split.

Delimiter (optional) – This parameter specifies where the supplied Expression should be split. By default, it set to space “ “.

Limit (optional) – This parameter specifies the maximum number of substrings to be returned. By default, this parameter is set to -1.

Compare (optional) – This parameter represents the type of comparison that should be used for the substrings. The default value is set to vbBinaryCompare.

 It can have the following values:

vbBinaryCompare – It performs a binary comparison

vbTextCompare – It performs a text comparison

vbDatabaseCompare – It performs a database comparison

Return

This function returns a one-dimensional array of substrings after splitting a string into a number of substrings.

Example 1

Output

Amar
Akbar
Anthony
VBA Split Function

Example 2

Output

House No:823
 C-Block
 Plot-2
 Rajori Garden
 Delhi
VBA Split Function

Pin It on Pinterest

Share This