SPLIT in Google Sheets
Splits text at a delimiter and puts the parts in the cells to the right.
Syntax
SPLIT(text, delimiter, [split_by_each], [remove_empty_text])- text
- The text to split.
- delimiter
- The character or characters to split at.
- split_by_each (optional)
- TRUE (the default) splits at each character on its own. FALSE splits only at the whole delimiter.
- remove_empty_text (optional)
- TRUE (the default) skips empty parts.
Examples
C1
=SPLIT(1A2,2" ")| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Ann | Berg | |
| 2 | Ann Berg |
In plain words: Split 1the name in A2 at 2each space.
C1=SPLIT(A2,"-")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Date as text | 2024 | 3 | 15 | |
| 2 | 2024-03-15 |