TEXTSPLIT

The TEXTSPLIT function splits the contents of a cell or string by a specified delimiter. TEXTSPLIT is the inverse of TEXTJOIN.

TEXTSPLIT(string, column-delimiter, row-delimiter, ignore-empty, case-sensitive, pad-with)

string: Any value.

column-delimiter: The text or string indicating where to split the text across columns. In addition, delimiter can be either empty or a reference to a string in another cell.

row-delimiter: The text or string indicating where to split the text down rows.

ignore-empty: An indicator for including empty cells in the result.

preserve empties (0 or omitted): Empty cells are included in the result.

ignore empties (1): Empty cells aren’t included in the result.

case-sensitive: An indicator for matching text case in the delimiter.

case sensitive (0 or omitted): Delimiter matching is case sensitive.

ignore case (1): Ignore text case in the delimiter.

pad-with: The value to fill cells in the result. Default is an empty cell.

Examples

Given A1=A, B, C, D, E:

=TEXTSPLIT(A1,“ “,,0) returns the table below.

A

B

C

D

E

2

A,

B,

C,

D,

E

=TEXTSPLIT(A1,, “ “, 0,0) returns the table below.

A

2

A,

3

B,

4

C,

5

D,

6

E

Given A1=Olivia Carol Smith-Annalise Robin Banks-Meredith Jean Washington:

=TEXTSPLIT(A1, “ “, “-“,1,0) returns the table below.

A

B

C

2

Olivia

Carol

Smith

3

Annalise

Robin

Banks

4

Meredith

Jean

Washington

See alsoTEXTJOINCONCAT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
उपयुक्त आहे का?
कॅरॅक्टर मर्यादा : 250
कमाल कॅरॅक्टर मर्यादा 250 आहे.
तुमच्या प्रतिक्रियेबद्दल धन्यवाद.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.