Contact
12 programs
Explore the site

TEXTSPLIT in Apple Numbers: Split Text into Columns and Rows

Text Intermediate Apple Numbers

Split text into columns or rows in Apple Numbers with TEXTSPLIT, including empty fields, case matching, padding and reproducible examples.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked

Quick answer: TEXTSPLIT separates one string into an array of values by delimiters. The column delimiter divides the text horizontally; the row delimiter divides it vertically. In an English-separator spreadsheet, =TEXTSPLIT("red,green,blue",",") is expected to yield three adjacent values: red, green, blue. This is a reasoned expected output, not a screenshot or a formula executed in Apple Numbers. Apple’s TEXTSPLIT documentation verifies the general rule.

Exact Apple Numbers syntax

=TEXTSPLIT(string,column-delimiter,row-delimiter,ignore-empty,case-sensitive,pad-with)
Apple argument (in order) Type and meaning Documented default or omission Source
string Any value, converted for splitting into text Provide the source value; no omitted default documented Apple TEXTSPLIT
column-delimiter Text, cell reference containing a string, or an empty argument; comma, semicolon, tab and custom text are supported choices Empty is allowed for row-only splitting; don’t leave both delimiters undefined in a production formula Same Apple reference
row-delimiter Text identifying a row break; line feed, carriage return, CR/LF, Unicode line separator or custom text Apple’s examples omit it for column-only splitting Same Apple reference
ignore-empty Modal selector: 0 keeps empty outputs, 1 omits them 0 (preserve empties) when omitted Same Apple reference
case-sensitive Modal selector: 0 means case-sensitive; 1 means ignore case 0, despite the potentially confusing argument name Same Apple reference
pad-with Value inserted where split rows have different column counts Empty cell when omitted Same Apple reference

The argument names above are Apple’s actual names, not Excel’s parameter names. Apple’s documentation uses six positions but its examples demonstrate omitted positions with consecutive commas. The specification does not establish that Excel’s array-constant delimiter syntax or all Excel error codes transfer to Numbers.

Reproducible worksheet 1: split a product label

In a Numbers table with a header row, set A2 to the literal text red,green,blue. Leave enough empty result cells, then enter this formula in an adjacent result area:

=TEXTSPLIT(A2,",")

Expected horizontal result, independently reasoned by splitting on literal commas:

Result column 1 Result column 2 Result column 3
red green blue

For a vertical result, set A3 to North-South-West and use:

=TEXTSPLIT(A3,,"-",0,0)

The empty second-argument position requests no column delimiter. Expected vertical entries are North, South, West. This follows Apple’s documented row-delimiter semantics; the actual allocation of array output cells must be checked in the target Numbers build and table layout.

Reproducible worksheet 2: names and records

Apple provides a useful exact official example: A1 contains Olivia Carol Smith-Annalise Robin Banks-Meredith Jean Washington and the formula is:

=TEXTSPLIT(A1," ","-",1,0)

The vendor’s published output is:

Row First Middle Last
1 Olivia Carol Smith
2 Annalise Robin Banks
3 Meredith Jean Washington

This is documentation-checked, not an independently observed Numbers execution. Notice the exact order: space splits columns, hyphen splits rows.

Advanced: keep empty fields, ignore them, or pad uneven rows

Put red,,blue in A4. The documented ignore-empty=0 setting keeps the empty item between the commas; ignore-empty=1 omits it:

=TEXTSPLIT(A4,",",,0)
=TEXTSPLIT(A4,",",,1)

Expected reasoned results are [red, empty, blue] for 0 and [red, blue] for 1. This matters for importing CSV-like records: ignoring an empty field can shift the meaning of later columns. Do not use this as a full CSV parser—quoted embedded delimiters, escaped quotes, and multiline quoted fields require rules not established by Apple’s TEXTSPLIT reference.

For uneven row widths, place A|B-C in A5 and use:

=TEXTSPLIT(A5,"|","-",0,0,"(missing)")

Mathematically expected shape is two rows by two columns: [A, B] and [C, (missing)]. Apple’s documentation establishes that pad-with supplies values for missing positions, whereas the default leaves an empty cell. The exact rendering in Numbers has not been natively tested.

Important case-matching trap

Apple’s parameter is called case-sensitive, but its values are easy to reverse: 0 does distinguish upper and lower case; 1 ignores case. With A6=oneXtwoxthree and delimiter "x", a case-sensitive split leaves uppercase X untouched, while the ignore-case setting recognizes both. Treat these as expected string transformations, not observed application results.

Troubleshooting and limitations

Situation What to check or change
Unexpected extra blank column A pair of adjacent delimiters generates an empty token when ignore-empty is 0 or omitted.
Missing data shifts column labels If positional fields matter, keep empties rather than setting ignore-empty to 1.
Uppercase delimiters are ignored Confirm the fifth argument: 0 = case-sensitive, 1 = ignore case.
Extra blank output cells Split rows have uneven widths; provide a deliberate sixth pad-with value if needed.
Results are blocked by existing cells Place array-output formulas in a clear region and validate spill behaviour in your particular Numbers release. Apple’s 14.4 release notes describe multi-cell spilling, but placement and error text were not tested here.
Formula isn’t accepted after copying from an English example If the locale uses comma as its decimal separator, change argument separators to semicolons; keep literal delimiters in quotation marks.
Text includes commas within quoted fields TEXTSPLIT is not documented as a CSV parser with quote escaping. Preprocess with a proper import workflow instead of assuming quotation rules.
Invalid argument or unavailable function Review the argument count, quote placement and installed app’s Function Browser. No specific Numbers error message was observed.

Regional settings, tables and availability

Apple’s Functions overview uses comma argument separators in English. If your device uses a comma decimal separator, use semicolons between function arguments, e.g. =TEXTSPLIT(A2;",") for a comma-delimited string. The delimiter string still contains a comma because it is the data separator, not a function-argument separator.

Cell A2 is relative to its own Numbers table, not an Excel-like global worksheet grid. For other tables, Apple’s reference syntax documents Table 2::A2; a different sheet can require Sheet 2::Table 2::A2. Apple’s help is edition 15.4 as of 2026-10-12, but this is not proof of the first supported release on each device. Its Mac release notes describe spilled-array support in Numbers 14.4; verify the function is present in the actual Mac/iPad/iPhone/iCloud edition used.

Excel portability: do not assume identical padding

Microsoft’s official Excel TEXTSPLIT reference documents TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty],[match_mode],[pad_with]). Excel’s fifth argument is called match_mode; the numeric modes have analogous case-sensitive/insensitive meanings. Important difference: Excel documents #N/A as its default pad_with, whereas Apple’s 15.4 page says the default is an empty cell. Do not port error-detection formulas across these engines without checking this distinction. Neither Excel execution nor Apple Numbers execution was performed.

Apple TEXTJOIN is identified by Apple as TEXTSPLIT’s inverse (see the linked function catalogue); Apple ARRAYTOTEXT converts an entire array to one text string instead of splitting text into an array. The above official links and Apple’s TEXTSPLIT page were accessible when checked 2026-10-12.

Verification status: Apple’s exact six-argument signature, modes, default values and example output were documentation-checked in Formulas and Functions Help 15.4 on 2026-10-12. Original examples are independently reasoned as specified; no native Apple Numbers execution or application screenshots were performed.