Excel TEXTSPLIT function⚡ Split text into cells

The TEXTSPLIT function: Split text into cells. Split names and places typed together. This page shows the syntax, a worked example with its result and how the formula reads.

What does TEXTSPLIT do?

Split text into cells. Split names and places typed together

TEXTSPLIT syntax

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

Arguments in square brackets [ ] are optional · argument names follow Microsoft's documentation

TEXTSPLIT example with the result

=********

👑 Ready-to-use example formula for VIP supporters only · Become VIP

Formula in cell C2 Yellow cells = result

ABCDE
1CombinedSplit
2Somchai,Jaidee,BangkokSomchaiJaideeBangkok

How it reads: Cuts the text at each comma into separate cells

💡 Excel version Works in Excel for Microsoft 365 and Excel 2024 or later, per Microsoft's function list · older versions show #NAME?

Frequently asked questions about TEXTSPLIT

What does TEXTSPLIT do?

Split text into cells. Split names and places typed together

What does the TEXTSPLIT example return?

The example formula in cell C2 spills its results into several cells starting at C2, as shown in the example table.

Which Excel versions have TEXTSPLIT?

Excel for Microsoft 365 and Excel 2024 or later, according to Microsoft's function list. Older versions show #NAME?.

Source: support.microsoft.com

Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning

🤖
Posting...
Please wait a moment
Social VIP Classroom
Home
Thai Smiles Profile