Can You Split a Cell in Google Sheets? Here’s How

Can You Split a Cell in Google Sheets? Here's How

Yes, you can split the text in a Google Sheets cell into separate columns using Data > Split text to columns. You cannot divide one cell itself into smaller cells: Sheets places the separated pieces in neighboring cells, so make sure those destination cells are available before you split.

What “splitting a cell” means in Google Sheets

People often use “split a cell” to describe two different tasks. One is separating text stored together, such as a full name or a list of tags. The other is changing the spreadsheet grid so that one cell becomes several smaller cells. Google Sheets supports the first task, not the second. A cell is one position in the grid; to distribute its contents, Sheets writes the parts into adjacent cells in the same row or, with a formula, into a vertical range.

For example, a cell containing Maya Chen | 28 | Seattle can be separated into three values: Maya Chen, 28, and Seattle. Those values occupy three neighboring cells. This is useful for cleaning imported lists, separating names or codes, and preparing data for sorting, filtering, or analysis.

Splitting is different from unmerging cells. If several grid cells were merged into one large-looking cell, use Format > Merge cells > Unmerge to restore the grid cells. Unmerging does not divide text at a comma or other character; it changes the cell layout.

Split text to columns with the menu

For a one-time separation, the built-in command is usually the quickest option. Open the spreadsheet in a web browser, select the cell or range containing the text, and use the menu path Data > Split text to columns. Sheets displays a separator control near the selected data. Choose a detected separator or select a specific one from its menu.

Check that the cells immediately to the right of the selected data are empty, or move the data to a sheet with enough free columns.
Select the cell or range you want to separate.
Choose Data > Split text to columns.
In the separator control, choose Detect automatically, or choose the character used between values, such as comma, space, or a custom delimiter.
Review the result across the row. If the pieces are not separated as intended, undo the change and try a different separator.

Suppose A2 contains Maya Chen,28,Seattle. Selecting A2 and choosing comma as the separator puts the three values in A2, B2, and C2. If each row in A2:A50 contains a similarly formatted record, select that range before splitting. Each row is divided using the chosen separator, and the resulting values occupy columns alongside the original rows.

Depending on the text and the selected range, automatic detection may choose a separator that is not the one you intended. For predictable results, explicitly choose the delimiter when you know it. The menu command changes the cell contents into separate values; it is not a live connection that automatically updates if the original text later changes.

Choose the right separator

The separator is the character or text that marks the boundary between values. Common examples include a comma in a list, a space between words, a tab in copied data, or a pipe character in exported records. The best choice is the one that consistently distinguishes fields without appearing inside the values themselves.

Comma: Useful for simple text such as red,green,blue. It may be a poor choice if entries themselves contain commas, such as addresses.
Space: Can separate a first and last name, but it may produce extra columns for middle names or multiword locations.
Custom delimiter: A distinctive marker such as | can be more reliable when the data uses it consistently.
Detect automatically: Convenient for obvious patterns, but check the output rather than assuming the detected separator is correct.

A practical test is to inspect several representative records before splitting a large range. If a delimiter occurs inside a value, a simple split may divide that value too. For instance, splitting Portland, Oregon, USA at every comma creates three pieces, even if the intended fields were only city and country. When records include quoted commas or inconsistent formatting, use a more suitable import or cleanup process instead of assuming that a delimiter split will understand the data structure.

Use the SPLIT function for repeatable results

If the source text may change, or you want a repeatable transformation, use the Google Sheets SPLIT function. It returns the pieces in neighboring cells and updates when its source changes. With the text in A2, enter a formula in an empty cell to the right or elsewhere with enough empty space for its results.

With the text Maya Chen | 28 | Seattle in A2, enter =SPLIT(A2," | ",FALSE) in an empty cell. The formula returns Maya Chen, 28, and Seattle across three cells. The third argument, FALSE, tells Sheets to treat the full string consisting of a space, pipe, and space as one delimiter. Without that setting, the function normally treats each character in the delimiter argument separately, which can create unintended splits.

With a comma-separated value such as red,green,blue in A2, the simpler formula =SPLIT(A2,",") returns the three items across the row. The function can also accept a cell reference for the delimiter; that is useful when the separator is stored in another cell. If the output area is occupied, clear or move the blocking values before placing the formula. A formula cannot fill cells that already contain data.

Unlike the menu command, a formula keeps the original text in its source cell. You can copy the formula down for many records, then copy the results and use Edit > Paste special > Values only if you need fixed values rather than formulas. Check the output before removing the source, especially if other formulas depend on it.

Split text into rows or separate only part of a value

Split text to columns is designed to distribute pieces horizontally. If you want the pieces to run down a column instead, combine TRANSPOSE and SPLIT. With red,green,blue in A2, enter =TRANSPOSE(SPLIT(A2,",")) in an empty vertical area. The result runs downward into three rows. As with any formula that returns multiple values, leave the required output cells clear.

Sometimes the goal is not to split every separator, but to extract one specific piece. For example, a value such as INV-2026-041 may contain a category, year, and number separated by hyphens. Splitting the whole string can be appropriate if all three parts are useful. If you only need one part, a formula designed to extract text or a careful cleanup step may be simpler. The right approach depends on whether you need a one-time change, a live result, or just one field from the original value.

There is no universal rule that every space or punctuation mark represents a field boundary. A full name may have two or three words; a product description may contain commas; and a code may use the same character both as a separator and within a value. Inspect the source pattern first, then choose a method that matches it.

Prevent overwriting data and fix common problems

The most important precaution is to make room for the results. Splitting one cell into four parts requires space in that row for four output cells, including the original cell’s position. If those neighboring cells contain useful data, the split may replace it or prompt you about the existing content. Move the source data to an empty area or make a copy of the sheet before proceeding. For important records, keeping an untouched source column makes it easier to verify the transformation.

Everything splits into too many pieces: Check whether the delimiter contains several characters and whether the function is treating each character separately. For SPLIT, use FALSE as the third argument when you want the delimiter treated as one exact string.
A value stays in one piece: Confirm that the separator you selected actually appears between the values. Watch for spaces after commas or unexpected tabs.
Extra blank pieces disappear: SPLIT removes empty text by default. Its optional fourth argument can control that behavior; use =SPLIT(A2,",",TRUE,FALSE) when you want to preserve empty pieces created by consecutive commas or a delimiter at the end.
The formula shows an error or does not expand: Check that the source reference is valid and that the cells needed for the results are empty.
Dates or numbers look different afterward: Check the resulting values and their formatting. If exact text representation matters, preserve a copy of the original data before changing it.

For example, with red,,blue in A2, the formula =SPLIT(A2,",",TRUE,FALSE) preserves the empty middle item, so the output has red, a blank value, and blue. That can matter when the position of each field has meaning. The menu route is better suited to a straightforward one-time split; formulas are often easier to inspect and repeat when blanks, changing source data, or multiple records are involved.

Google Sheets compared with Excel

Google Sheets and Microsoft Excel both offer ways to separate delimited text, but their menus and formula details are not identical. In Google Sheets, use Data > Split text to columns or the Sheets SPLIT function. In current Excel for Microsoft 365 on Windows, the comparable menu command is Data > Text to Columns, and Excel also has its own text functions. Do not assume that a Google Sheets formula or menu path will work the same way in Excel.

If you are following instructions written for Excel, look for the equivalent action rather than copying the menu path literally. Likewise, if a spreadsheet is shared between Sheets and Excel, verify formulas after conversion because functions and supported behavior can differ. For a basic comma-delimited list, both programs can separate values, but the exact steps depend on which application you are using.

Frequently Asked Questions

Can I split one Google Sheets cell into two actual cells?
No. You can distribute its contents into neighboring cells, but you cannot divide a single position in the grid into smaller cells. Insert or use adjacent rows or columns to make room for the separated values.

Can I split a cell diagonally in Google Sheets?
No. A diagonal division is not a cell-layout feature in Google Sheets. You can use borders or formatting to suggest a division visually, but the cell remains one cell and cannot hold two independently addressable values.

Can I split text into rows instead of columns?
Yes, with a formula. For text in A2 separated by commas, =TRANSPOSE(SPLIT(A2,",")) returns the pieces vertically, provided the output cells below the formula are empty.

Will splitting change the original cell?
The menu command changes the selected data into separated values. A SPLIT formula leaves the source text in place and displays results elsewhere. Keep a copy if you need to preserve the original exactly.

Can I undo Split text to columns?
Usually, use Edit > Undo immediately after the operation to reverse it. If you have made further changes, undo may reverse those too; a saved copy or preserved source column is a safer backup for important data.

Why does Split text to columns overwrite nearby values?
The separated pieces need neighboring cells, and those cells are the output destination. Move the source to an empty area or clear the destination cells only after confirming their contents are not needed.

Choosing a safe method

Use Data > Split text to columns when you have consistent text and want to make a one-time change. Use SPLIT when you want the result to update with its source, need to fill a formula down a list, or want to preserve the original value. Use TRANSPOSE with SPLIT when the output should run vertically. In every case, identify the delimiter, check a few records, and leave enough empty space for the output. That simple preparation prevents the most common errors and makes the result easier to trust.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.