Split a Cell in Google Sheets: What Actually Works

How-to basics · Updated November 22, 2026

In Google Sheets, you cannot divide one ordinary cell into two independently editable cells with a dedicated split-cell command. To separate text inside a cell, select it and choose Data > Split text to columns; to divide a merged cell, use Format > Merge cells > Unmerge.

What “split a cell” can mean

The phrase can refer to a few different jobs, and the right method depends on what is in the cell. Google Sheets treats these as separate tasks:

  • Separate text: Turn a value such as Jordan Lee, Portland into multiple values in neighboring columns. Use Split text to columns or the SPLIT function.
  • Unmerge cells: Restore the original cell grid after several cells were combined with Merge cells.
  • Create a visual division: Use borders or spacing to make a table look divided. This changes appearance, not the underlying cell structure.

This distinction matters because a cell is already one unit at the intersection of a row and column. If you want two separate places to enter data, you need to use adjacent cells, not cut one cell in half. Inserting a column can create more room in the sheet, but it does not split the contents of a cell automatically.

Split text into columns with the menu

For a one-time separation, the menu command is often the quickest choice. It is useful for imported lists, names, addresses, or values separated consistently by commas, spaces, tabs, or another character.

  1. Select the cell or range containing the text. If you select a range, make sure each row follows a compatible pattern.
  2. Choose Data > Split text to columns.
  3. Use the separator control that appears near the selected data. Choose a detected separator, a listed option such as comma or space, or a custom separator.
  4. Check the output in the cells to the right. Undo immediately with Ctrl+Z on Windows if the split is not what you intended.

For example, splitting Jordan Lee, Portland on a comma creates Jordan Lee in one column and Portland in the next. The command separates text at the chosen delimiter; it does not understand that a name is a first name plus a last name, or that a comma is part of a correctly formatted address. Choose the separator based on the structure of the data, not merely on what characters happen to appear.

Before using the command, leave enough empty columns to the right for the results. This gives you room to inspect the output and avoids collisions with other data. If the selected rows contain different numbers of parts, some rows may have blank results in later columns. Review the full range after splitting rather than assuming every row was interpreted identically.

Use the SPLIT function for repeatable results

If new values will keep arriving or you want to preserve the original text, use the Google Sheets SPLIT function. Unlike the menu command, a formula recalculates when its source cell changes. It also leaves the source value in place, which can be useful for a clean raw-data column and separate output columns.

With the unsplit text in A2, enter this formula in B2 to separate it at each comma followed by a space:

=SPLIT(A2,", ",FALSE,TRUE)

If A2 contains Jordan Lee, Portland, Oregon, the result appears across B2, C2, and D2 as Jordan Lee, Portland, and Oregon. The third argument, FALSE, tells the function to treat the delimiter as the exact two-character sequence comma-space. The fourth argument, TRUE, tells it to ignore empty results when separators repeat or appear at an edge.

The exact-delimiter setting is easy to overlook. By default, SPLIT can treat each character in a delimiter string as its own separator. For instance, a delimiter written as - could be read as a space, hyphen, or space separately. Set the third argument to FALSE when you mean the complete sequence, such as space-hyphen-space. If you instead want to split at any one of several individual characters, the default behavior can be useful.

Formula results expand into adjacent cells. Keep those destination cells empty; otherwise Sheets may report that the array result could not expand. If you copy the formula down a column, check that each row has enough open cells for the number of pieces it produces.

Put split results into rows instead

Sometimes a list needs to run downward rather than across. The menu command is intended to place separated pieces in neighboring columns. To turn a delimited list into a vertical list with a formula, combine SPLIT with TRANSPOSE.

With red, blue, green in A2, enter this formula in B2:

=TRANSPOSE(SPLIT(A2,", ",FALSE,TRUE))

The result fills B2:B4 with red, blue, and green. As with a horizontal result, the cells below the formula must be free for the expanded output. This is a useful way to reshape a short list, but it does not create a separate worksheet row for every item in a large data table. For a larger transformation, plan the output range and verify that each source record has the expected number of values.

Unmerge a merged cell

If by “split” you mean undo a cell that spans multiple columns or rows, select the merged cell and choose Format > Merge cells > Unmerge. The grid returns to separate cells. Unmerging does not restore text that was never stored separately: a merge generally displays the contents of the upper-left cell of the merged range, while other cells’ contents may have been removed when the merge was made.

After unmerging, the former range is available as individual cells, but only the retained value appears automatically. If you need different values in each cell, enter them yourself or restore them from an earlier version or backup. If the goal is only to center a heading across several columns, consider using alignment options rather than merging data cells; merged cells can make sorting, filtering, selecting ranges, and copying formulas less convenient.

Prepare the data before splitting

Splitting works best when the source values follow a consistent pattern. A clean delimiter is more reliable than guessing based on spaces or punctuation. For example, splitting full names on a space may work for Jordan Lee, but it produces an unreliable result for Mary Ann Smith if the intended output is first name and last name. The delimiter can separate words, but it cannot infer which words belong together.

Check these details before running a split:

  • Identify the actual separator. A comma, semicolon, tab, line break, or repeated sequence may be the intended boundary.
  • Look for inconsistent spacing. Some entries may have a space after a comma and others may not. A formula using an exact comma-space delimiter will not treat those patterns identically.
  • Check for the delimiter inside values. A comma in an address or quoted field can create an extra piece if the data is not consistently formatted.
  • Keep a copy of the original. Duplicate the column or sheet when the source is important, especially before applying a one-time menu operation to many rows.
  • Reserve space for output. Confirm that cells beside or below the formula result are empty.

For recurring imports, keeping an untouched source column makes errors easier to diagnose. You can compare a split result with the original and correct unusual records without having to reconstruct the source text.

Common problems and practical fixes

Everything splits at every space. The separator was probably set to Space, or the formula uses a space as its delimiter. This is fine for a simple phrase but usually not for names with middle names or multiword locations. Use a more distinctive delimiter if the source contains one.

The result is in the wrong columns. Check whether the separator control is set to Detect automatically or to a specific character. Automatic detection is convenient for regular data, but it may choose an unsuitable separator when values contain several kinds of punctuation. Select the separator explicitly and inspect a representative row first.

A formula gives an expansion error. The cells where the result needs to appear are not all empty, or the output area is blocked in another way. Clear the needed destination cells or move the formula to an open area. Do not erase neighboring information until you have confirmed what occupies it.

Some rows produce extra or missing pieces. The records may not share the same delimiter pattern. For example, a row might have a comma-space while another has a semicolon, or a delimiter might occur inside one value. Correct the source pattern or handle exceptional rows separately; a basic split does not interpret the meaning of the text.

A split seems to have lost information. Check the original source or use Undo if the operation just happened. This is one reason to keep a copy before a large menu-based split. For formula-based work, the original remains in its source cell unless you overwrite it yourself.

How Google Sheets differs from Excel

The underlying idea is similar in both programs, but the commands are not identical. In Google Sheets in a web browser, the built-in command is Data > Split text to columns. In Excel for Microsoft 365 on Windows, the comparable menu-driven feature is generally called Text to Columns and is found on the Data tab. Do not follow Excel instructions that name a Text to Columns wizard when working in Sheets; use the Sheets menu path above.

Google Sheets also has its own SPLIT function for dividing text by a delimiter. The examples here use Google Sheets syntax and its browser interface, not Excel-specific functions or ribbon paths. If you open the same file in another spreadsheet program, menu names, formula behavior, and separator conventions may differ. In either program, leave room for the output and retain a source copy when the original data matters.

Frequently Asked Questions

Can I split one Google Sheets cell into two cells?
Not by cutting the cell’s grid area in half. You can split the text it contains into neighboring cells with Data > Split text to columns or with the SPLIT function. To create two distinct places for data, use separate cells in adjacent columns or rows.

How do I split a cell by comma in Google Sheets?
Select the cell or range and choose Data > Split text to columns, then choose comma as the separator. For a formula, with the text in A2, enter =SPLIT(A2,",") in an empty cell. The pieces expand horizontally, so leave space to the right.

Can I split text into rows instead of columns?
Yes. Use TRANSPOSE(SPLIT(...)) to turn the horizontal split result into a vertical one. Make sure the cells below the formula are empty so the results can expand.

How do I split a merged cell without losing its contents?
Select the merged cell and choose Format > Merge cells > Unmerge. The grid separates again, but unmerging does not distribute the displayed text among the restored cells. Copy or record any needed information before changing the layout.

Why does Google Sheets not split my text correctly?
Most often, the chosen delimiter does not match every row, or the delimiter also appears inside the values. Check the source pattern, select a specific separator instead of relying on detection, and test on a copy or a small sample before applying the split to a full dataset.

Related

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.