<div class="raw-html-embed">	<p>The <b>TEXTSPLIT</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#textdata" onclick="onhyperlinkclick(this)">text and data functions</a>. It is used to split text strings through column and row delimiters.</p>

	<h5 class="pt8">Syntax</h5>
	<p><b><em>TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])</em></b></p>
	<p>The <b>TEXTSPLIT</b> function has the following argument:</p>
	<table style="width: 40%">
		<tbody>
			<tr>
				<th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
				<th style="background-color: #f4f4f4"><b>Description</b></th>
			</tr>
			<tr>
				<td><b><em>text</em></b></td>
				<td>The text you want to split.</td>
			</tr>
			<tr>
				<td><b><em>col_delimiter</em></b></td>
				<td>An optional argument. It is used to set the text that marks the point where to split the text across columns.</td>
			</tr>
			<tr>
				<td><b><em>row_delimiter</em></b></td>
				<td>An optional argument. It is used to set the text that marks the point where to split the text down rows.</td>
			</tr>
			<tr>
				<td><b><em>ignore_empty</em></b></td>
				<td>An optional argument. It is used to specify <b>FALSE</b> to create an empty cell when two delimiters are consecutive. Defaults to <b>TRUE</b>, which creates an empty cell.</td>
			</tr>
			<tr>
				<td><b><em>match_mode</em></b></td>
				<td>An optional argument. It is used to search the text for a delimiter match. By default, a case-sensitive match is done.</td>
			</tr>
			<tr>
				<td><b><em>pad_with</em></b></td>
				<td>Is used to set the value with which to pad the result. Defaults to #N/A.</td>
			</tr>
		</tbody>
	</table>

	<h5 class="pt8">Notes</h5>
	<p>Please note that this is an array formula. To learn more, please read the <a href="../../docs/userguides/spreadsheet_editor/InsertArrayFormulas.aspx" onclick="onhyperlinkclick(this)">Insert array formulas</a> article.</p>
	<p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>TEXTSPLIT</b> function.</p>

	<h5 class="pt8">Examples</h5>
	<p>The figure below displays the result returned by the <b>TEXTSPLIT</b> function.</p>
	<p><img alt="TEXTSPLIT Function" src="https://static-helpcenter.teamlab.info/textsplit_2503d3011e.png"></p></div>

TEXTSPLIT Function

Docs

Argument	Description
*text*	The text you want to split.
*col_delimiter*	An optional argument. It is used to set the text that marks the point where to split the text across columns.
*row_delimiter*	An optional argument. It is used to set the text that marks the point where to split the text down rows.
*ignore_empty*	An optional argument. It is used to specify FALSE to create an empty cell when two delimiters are consecutive. Defaults to TRUE, which creates an empty cell.
*match_mode*	An optional argument. It is used to search the text for a delimiter match. By default, a case-sensitive match is done.
*pad_with*	Is used to set the value with which to pad the result. Defaults to #N/A.

TEXTSPLIT Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud