How to Split Cells in Google Sheets
Use SPLIT when one cell contains structured text—such as a full name, SKU, or comma-separated list—and you want each part in its own cell. The formula spills the pieces horizontally and keeps the result connected to the source value.
Reviewed by the SheetsX team
Optional arguments control multi-character delimiters and whether empty pieces are removed.
Five fictional full names spill into first-name and last-name columns.
SheetsX checks every split value, preserves A1:A6, and reports the exact changed range.
How do you split cells in Google Sheets?
To split text from A2 into separate cells, enter =SPLIT(A2," ") in B2. The formula divides the text at each space and spills the pieces across the row. Fill the formula down for more records. For a one-time conversion instead of live formulas, select the source cells and choose Data > Split text to columns.
Watch SheetsX split five names with live formulas
The Agent clears incorrect placeholder output, writes =SPLIT(A2," ") through =SPLIT(A6," "), verifies all ten returned name parts, applies readable formatting, and confirms that no cells outside A1:C6 changed.
The recording uses fictional names. Each source contains exactly one first name and one last name separated by a single space so the simple delimiter produces two columns.
“Replace the incorrect hardcoded split output in B1:C6 on Sheet8. Keep A1:A6 unchanged. Set B1 to First Name and C1 to Last Name. Clear B2:C6, enter =SPLIT(A2," ") in B2, and fill the formula down through B6 so each full name splits into first and last name. Verify the five rows are Ava | Chen; Liam | Brooks; Mia | Santos; Noah | Patel; Zoe | Martin, in that order. Remove the red fill from B1:C6, format A1:C1 with dark green fill and bold white text, use pale green fill for A2:C6, reply in English, and confirm no other cells changed.”
How to split cells in Google Sheets with SPLIT
Choose the delimiter in your source text, place the formula beside the first record, leave room for the spilled result, and fill the formula down.
- 1
Identify the delimiter
Inspect the source text and find the character that separates each part. Common delimiters include a space, comma, hyphen, slash, or pipe.
- 2
Enter the SPLIT formula
In the first output cell, enter =SPLIT(A2," ") to divide A2 at spaces. Replace the delimiter inside quotes when the source uses another separator.
- 3
Leave the output cells empty
SPLIT returns an array across adjacent columns. Clear only the cells in the expected spill range so existing values do not block the result.
- 4
Fill down and verify each row
Copy the formula down the output column, then compare every returned part with the original text. Check edge cases such as extra spaces, missing delimiters, and multi-word names.
Google Sheets SPLIT formula examples
Change the delimiter and optional arguments to handle names, CSV-style text, product codes, URLs, or consecutive separators.
| Use case | Formula or setting | What it does |
|---|---|---|
| Split a full name at a space | =SPLIT(A2," ") | Returns each space-separated name part in its own cell across the row. |
| Split comma-separated values | =SPLIT(A2,",") | Divides text wherever a comma appears. Use TRIM around the result or clean the source if spaces follow commas. |
| Split a product code at hyphens | =SPLIT(A2,"-") | Turns a code such as NW-204-BLUE into three adjacent cells. |
| Treat a delimiter string as one unit | =SPLIT(A2,"::",FALSE) | FALSE makes the two-character string :: act as one delimiter instead of splitting on either colon. |
| Keep empty pieces | =SPLIT(A2,",",TRUE,FALSE) | The fourth argument keeps empty cells when the source contains consecutive commas. |
Ask SheetsX to split and verify a range
A precise Agent prompt names the protected source, the output range, the exact delimiter, the expected rows, and the required formatting.
Install SheetsX- Open a new English Agent chat so the operation starts with clean context.
- Name the source and output ranges and state which cells must remain unchanged.
- Provide the exact SPLIT formula and tell the Agent how far to fill it down.
- List the expected output so the Agent can verify every row after writing formulas.
- Review the formula bar, spill results, formatting, and final scope-of-changes report.
Google Sheets split cells questions
Can you split one Google Sheets cell into multiple cells?+
You can split the text stored in a cell into adjacent cells with SPLIT or Data > Split text to columns. Google Sheets does not divide one grid cell into smaller physical cells; if the cell is merged, unmerge it instead.
What is the SPLIT syntax in Google Sheets?+
The syntax is SPLIT(text, delimiter, [split_by_each], [remove_empty_text]). The first two arguments are required. split_by_each and remove_empty_text are optional and both default to TRUE.
Why does SPLIT overwrite or fail to expand?+
SPLIT needs empty cells to the right of the formula. If an output cell already contains a value, clear only the blocked spill range and let the formula recalculate.
How do I split text into rows instead of columns?+
Wrap the formula in TRANSPOSE, for example =TRANSPOSE(SPLIT(A2,",")). SPLIT returns a horizontal array by default; TRANSPOSE rotates it vertically.
How do I split on a multi-character delimiter?+
Set split_by_each to FALSE. For example, =SPLIT(A2,"::",FALSE) splits only when the complete :: sequence appears.
What is the difference between SPLIT and Split text to columns?+
SPLIT is a live formula that updates when the source changes. Split text to columns is a one-time menu action that replaces the selected data with separate values and does not remain linked to the original text.
How do I remove extra spaces before splitting names?+
Use =SPLIT(TRIM(A2)," "). TRIM removes leading, trailing, and repeated ordinary spaces before SPLIT divides the cleaned text.