Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z
  - T
  - T.DIST
  - T.DIST.2T
  - T.DIST.RT
  - T.INV
  - T.INV.2T
  - T.TEST
  - TAKE
  - TAN
  - TANH
  - TBILLEQ
  - TBILLPRICE
  - TBILLYIELD
  - TDIST
  - TEXT
  - TEXTAFTER
  - TEXTBEFORE
  - TEXTJOIN
  - TEXTSPLIT
  - TIME
  - TIMEVALUE
  - TINV
  - TOCOL
  - TODAY
  - TOROW
  - TRANSPOSE
  - TREND
  - TRIM
  - TRIMMEAN
  - TRUE
  - TRUNC
  - TTEST
  - TYPE
  - UNICHAR
  - UNICODE
  - UNIQUE
  - UPPER
  - USDOLLAR
  - VALUE
  - VALUETOTEXT
  - VAR
  - VAR.P
  - VAR.S
  - VARA
  - VARISPARKLINE
  - VARP
  - VARPA
  - VBARSPARKLINE
  - VDB
  - VLOOKUP
  - VSTACK
  - WEBSERVICE
  - WEEKDAY
  - WEEKNUM
  - WEIBULL
  - WEIBULL.DIST
  - WINLOSSSPARKLINE
  - WORKDAY
  - WORKDAY.INTL
  - WRAPCOLS
  - WRAPROWS
  - XIRR
  - XLOOKUP
  - XMATCH
  - XNPV
  - XOR
  - YEAR
  - YEARFRAC
  - YEARSPARKLINE
  - YIELD
  - YIELDDISC
  - YIELDMAT
  - Z.TEST
  - ZTEST

TEXTSPLIT

This function splits text strings by using column and row delimiters.

Syntax

=TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])

Arguments

The function has the following arguments:

Argument	Description
text	Refers to the text you want to split.
col_delimiter	Refers to the text that marks the point where to spill the text across columns.
row_delimiter	[Optional] Refers to the text that marks the point where to spill the text down rows.
ignore_empty	[Optional] Specify FALSE to create an empty cell when two delimiters are consecutive. Defaults to TRUE, which creates an empty cell.
match_mode	[Optional] Searches the text for a delimiter match. By default, a case-sensitive match is done.
pad_with	[Optional] Refers to the value with which to pad the result. The default is #N/A.

Remarks

An array constant must be used if there is more than one delimiter. For example, to split by both a comma and a period, use =TEXTSPLIT(A1,{",","."}).

Data Types

Returns string data.

Examples

Version Available

This function is available in product version 16.0 or later.

!type=note
Note: The TEXTSPLIT function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.