SPLIT Function in Zoho Sheet: Syntax, Examples and Troubleshooting
Split text across a row in Zoho Sheet, distinguishing delimiter characters from a whole delimiter string and preserving empty fields when needed.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: With red-green-blue in A2, =SPLIT(A2;"-") is expected to return red, green, blue in adjacent cells. Two defaults matter: split_by=TRUE treats each delimiter character separately, and remove_blank=TRUE skips empty fragments.
Availability and version history
- Introduced: Added in December 2020, according to Zoho’s release history; no numbered cloud release is given.
- Availability: Currently documented in Zoho Sheet’s rolling web-service help; no final supported-version endpoint is identified.
- Scope: The web documentation is the checked reference. Mobile parity and behavior after exchanging files with other applications are not separately established.
- Checked: October 14, 2026, against the official SPLIT page, with independently calculated examples. No native Zoho Sheet test.
Syntax and arguments
=SPLIT(text; delimiter; [split_by]; [remove_blank])
| Argument | Meaning | Required or default |
|---|---|---|
text |
Source text | Required |
delimiter |
Character or text boundary | Required |
split_by |
TRUE uses each delimiter character separately; FALSE uses the complete delimiter text | Default TRUE |
remove_blank |
TRUE skips empty fragments; FALSE retains them | Default TRUE |
Zoho’s SPLIT reference prints commas in the syntax line and uses semicolons in one of its examples. This guide uses semicolons consistently; follow the formula editor’s separators in your configuration. Do not type the optional-argument brackets.
Reserve space for the results
Use a blank worksheet with at least seven columns and twenty rows. Keep source text in column A, and leave C:G free on the rows used below. Put each formula in column C only. Zoho’s dynamic-array guide says that one formula can extend into adjacent cells without Ctrl+Shift+Enter; obstructing contents produce #SPILL!.
SPLIT produces a horizontal row. For an explicitly two-dimensional row-and-column split, consult the TEXTSPLIT reference.
Reproducible examples
1. A one-character separator
Put red-green-blue in A2. Enter =SPLIT(A2;"-") in C2. Expect red, green, blue across C2:E2. With a one-character delimiter, there is no difference between treating the delimiter as one character or as one complete string.
2. Each character is a delimiter by default
Put XabYaZbW in A4. Enter =SPLIT(A4;"ab") in C4. Expect X, Y, Z, W across C4:F4. The a and b characters each act as boundaries, and the empty fragment between adjacent a and b is skipped by the default remove_blank setting.
3. Use the whole delimiter string
Put the same XabYaZbW in A6. Enter =SPLIT(A6;"ab";FALSE) in C6. Expect X, YaZbW in C6:D6. Only the complete sequence ab matches; the later isolated a and b remain inside the second fragment.
4. Preserve a missing middle field
Put A::B in A8. Enter =SPLIT(A8;":";TRUE;FALSE) in C8. Expect C8=A, D8=an empty field, E8=B. The blank-looking middle position belongs to the output array. With remove_blank omitted or TRUE, the expected output would occupy only two cells, containing A and B.
5. Distinguish a two-character boundary from repeated single characters
Put A::::B in A10. Enter =SPLIT(A10;"::";FALSE;FALSE) in C10. Expect A, empty field, B across C10:E10: there are two occurrences of the complete :: boundary.
Put the same text in A12. Enter =SPLIT(A12;"::";TRUE;FALSE) in C12. Expect A, empty field, empty field, empty field, B across C12:G12. Now each colon is a boundary, and all four colon boundaries contribute to the five fragments. Repeating a delimiter character in the delimiter argument does not create a longer token when split_by is TRUE.
Advanced example: keep fields aligned with their headings
In C15:E15, enter Code, Status, Quantity. Put A||10 in A16 and enter =SPLIT(A16;"|";FALSE;FALSE) in C16. Expect A under Code, an empty field under Status, and 10 under Quantity. This preserves the position of the missing status instead of shifting the quantity into its column.
Before performing arithmetic with an extracted quantity, confirm its stored type and convert numeric text explicitly if needed. The displayed fragment 10 alone does not prove that a receiving formula treats it as a number. ISNUMBER can help inspect that distinction.
If your source has meaningful spaces, make whitespace cleanup a separate decision. TRIM can normalize ordinary padding, but removing empty fragments and trimming nonempty fragments are different operations. Do not assume a simple delimiter splitter also implements quoted-field CSV escaping.
Troubleshooting
- Too many pieces: split_by may still be TRUE, so each character of a multi-character delimiter is being used separately.
- Columns moved left: remove_blank may still be TRUE. Supply FALSE when empty positions are meaningful.
- #SPILL!: inspect the intended output cells and move valuable content before making room.
- Name/reference errors: check the leading equals sign, double quotes around literal text, the source reference and the delimiter.
- Unexpected corner cases: the SPLIT page does not fully specify case sensitivity, empty delimiters, no-match behavior, overlapping tokens or every type-coercion rule. These examples do not assign exact results to those cases.
The source error table includes a generic not-found entry that refers to lookup functions. It is not sufficient evidence to promise that every absent SPLIT delimiter returns that error. Use the documented delimiter options and verify unusual input patterns in the intended workbook.