About This Article
This article was created using a generative AI-powered automation workflow. We reviewed official Microsoft TEXTSPLIT documentation and organized a minimal experiment to split a single-cell string by a delimiter and expand it into adjacent cells. This has not been re-verified on a live Excel instance.Verification Status: 📘 Official Microsoft documentation verified, Excel live instance unverified
Information verification date: October 3, 2026.
When delimited data, such as CSV-formatted text, is contained within a single cell, using TEXTSPLIT allows you to divide it into multiple columns using just a formula. In this example, we change the delimiter in one place and observe the difference in the results.
First, Split by Comma
Enter the following in cell A1:
red,green,blue
Enter the following formula in cell B1:
=TEXTSPLIT(A1,",")
Observe how red、green、blue spills to the right from cell B1.
Change One Parameter
Change cell A1 to the following:
red;green;blue
Modify only the delimiter in the formula.
=TEXTSPLIT(A1,";")
flowchart LR A["1セルの文字列"] --> B["TEXTSPLIT"] B --> C["delimiter"] C --> D["複数セルへspill"]
What Happens When the Delimiter Does Not Match
If the input uses semicolons but the formula still uses a comma, the data will not split at the expected positions. Before concluding that the data is corrupted, you can verify whether the actual delimiter matches the one specified in the formula.
For Professional Use
This can be used to parse codes pasted from systems, values copied from emails, or simple delimited data. However, since full CSV formats involve rules such as quotes and internal line breaks, avoid oversimplifying it as a complete replacement for a CSV parser.
Scope of Application for TEXTSPLIT
TEXTSPLIT is a very intuitive function for observing and splitting regular text strings within a single cell on the fly. By simply changing the delimiter by a single character, the output changes, allowing you to visually verify the structure of the input data.
On the other hand, formal CSV files include quoted fields, values containing delimiters, and values containing line breaks. Trying to completely parse such data using only simple TEXTSPLIT operations violates the original rules of CSV.Treating simple delimiter strings and full-fledged CSV files as distinct entitiesis the threshold.
Additionally, if there are existing values in the destination cells, a spill error may occur. Checking not only the formula but also the space where results are to be expanded makes it easier to troubleshoot why TEXTSPLIT fails to execute.
