Description

The TEXTSPLIT function takes a delimited list (values separated by a common character) and separates the values in that list into an array of rows.

Examples include a list of comma-separated values: 1,2,3,4,5

Syntax

TEXTSPLIT(Text [or cell reference], delimiter]) 

The TEXTSPLIT function uses the following parameters:

Parameter

Required/Optional

Description

Text

Required

The delimited text to be separated (may be typed into the function or be in a separate cell).

Delimiter

Required

The character that is used - in the Text - to separate the values.

Examples

Example #1

=TEXTSPLIT(D7,";")

Cell D7 contains a list separated by semicolons (and includes a blank value).

Results:

textsplit01.png

Example #2

=TEXTSPLIT("abc;xyz;123;890",";")

Description: Returns the segments abc, xyz, 123, and 890 as elements of a dynamic array.

Result:

textsplit02.png
Did this answer your question?