TEXTSPLIT Function in Excel: Syntax, Examples and Free Practice
TEXTSPLIT is an Excel Text function. Splits text into rows or columns using delimiters.
TEXTSPLIT syntax
Arguments
text: The text to work withcol_delimiter: The character that marks a new columnrow_delimiter: The character that marks a new row (optional)
When to use TEXTSPLIT
TEXTSPLIT is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice TEXTSPLIT online, free
Open the live Excel-style spreadsheet and try TEXTSPLIT yourself. No Excel install or sign-up needed to start.
Practice TEXTSPLIT now →Learn more
Read the tutorial: Split text into columns.
More Text functions
Frequently asked questions
What does the TEXTSPLIT function do in Excel?
Splits text into rows or columns using delimiters.
What is the syntax of TEXTSPLIT in Excel?
The syntax is =TEXTSPLIT(text, col_delimiter, [row_delimiter]). text: The text to work with; col_delimiter: The character that marks a new column; row_delimiter: The character that marks a new row (optional).
Where can I practice TEXTSPLIT online for free?
Open the free live spreadsheet on Cellgrids and try TEXTSPLIT yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts