Can You Split a Cell in Google Sheets?

No—you can’t divide one Google Sheets cell into two or more independent cells. You can split the text inside a cell across neighboring columns with Data > Split text to columns, or change the sheet’s layout so separate cells look like a divided area.

What “splitting a cell” means in Sheets

A cell is the intersection of one row and one column. Unlike a piece of paper, that grid has no command for drawing a new boundary through the middle of just one cell. A cell cannot be turned into two smaller cells while the rest of its row and column structure stays unchanged.

People often mean one of two different things when they ask how to split a cell. They may want to divide its contents—for example, put a first name and last name into separate columns. Or they may want to change the visible layout, perhaps so one area appears divided while neighboring cells remain wide. Sheets can help with both goals, but the methods are different.

Separate text: Split a value such as Jordan Lee into values in adjacent columns.
Change the grid: Add a row or column, then adjust the layout or borders to create separate cells.
Undo a merge: Unmerge a cell that was previously combined with neighboring cells.

How Split text to columns works

Google Sheets’ Split text to columns command takes text from a cell and distributes its parts horizontally into neighboring columns. You choose a separator, such as a comma, space, or semicolon, that marks where one part ends and the next begins. For example, a cell containing Jordan,Lee can be split at the comma so the two names occupy separate cells in the same row.

This changes where the text is stored; it does not carve the original cell into smaller pieces. The first part remains in the original column, and later parts go into columns to its right. If a value produces three parts, Sheets needs room for the original column plus two additional columns. The command does not automatically create a new row for each part.

That distinction matters when planning a sheet. If you need separate fields for sorting, filtering, or calculations, splitting the text into columns is often useful. If you need two independently editable areas inside a single grid position, the grid itself must be rearranged instead.

Steps to split text into columns

In Google Sheets in a web browser, use these steps to divide text based on a delimiter:

Select the cell or range containing the text you want to separate. If you select a range, check that the neighboring columns can hold all the resulting parts.
Choose Data > Split text to columns.
Use the separator control that appears to choose a delimiter. You can let Sheets detect one automatically, select a common separator, or choose a custom character.
Check the resulting columns. If the split is not what you intended, undo it promptly with Edit > Undo or Ctrl+Z on Windows and ChromeOS. On a Mac, use Command+Z.

For example, suppose column A contains the text Riley Chen, with first and last names separated by one space. Select the relevant cells, run Split text to columns, and choose Space. The first name will be in column A and the last name in column B. If some rows contain middle names, those rows may produce an extra part, so inspect the results rather than assuming every record has the same structure.

Splitting changes the cells on the sheet, so preserve a copy of important source data before applying the command to a large range. One simple safeguard is to duplicate the data in another column or make a copy of the sheet using the sheet tab’s menu. This is especially helpful if the original text will be difficult to reconstruct.

Choosing the right separator

The separator is the character or pattern that tells Sheets where to divide a value. The right choice depends on how the text was entered. A comma works for values such as North,West; a space may work for a two-part name; and a custom separator can be useful when a consistent symbol such as a vertical bar separates fields.

Comma: Useful for consistently comma-delimited values, such as Maple Street,Portland.
Space: Suitable for fixed patterns with spaces, but risky when a field itself may contain multiple words.
Custom character: Often a better choice when the data uses a marker that does not appear inside the values.
Automatic detection: Convenient for plainly separated text, but verify the output when the source has mixed formats.

Consider Alex Morgan Lee. Splitting at every space makes three pieces, not necessarily a first name and surname. Likewise, a comma in an address may be part of the intended address rather than a boundary between fields. If the delimiter appears inside some values, a simple split may produce unwanted extra columns. Clean or standardize the source first, or choose a separator that reliably marks the intended boundary.

Make a visual split with separate cells

If your goal is appearance rather than separating text, create the layout from existing grid cells. For instance, if a form needs two side-by-side entry areas, use two neighboring columns, adjust their widths, and apply borders from the Sheets toolbar. The result can look like one larger area divided into two sections, while each section remains a real cell that can hold its own value.

If the rest of the sheet needs a wider heading or label, you can merge cells in that other area, but do so carefully. A common layout uses two ordinary cells in the row where separate entries are needed and merges cells across those columns in rows where a single heading should span the width. This is a layout workaround, not a way to split a cell: the two entry areas exist because they are separate cells in the grid.

You can also insert a column or row when the current grid does not have enough cells for the layout. Right-click a column letter or row number and use the insert option, or use the Insert menu. Inserting affects the grid across the sheet, not just one individual cell, so check formulas, references, and nearby content after changing the structure.

What to do with merged cells

A merged cell is made by combining a group of adjacent cells for display. It can look like one large cell, but it is not a cell that has been split in reverse. To restore the underlying grid, select the merged area and use Format > Merge cells > Unmerge. The original cell boundaries return, although the contents are not automatically divided into separate values.

Unmerging is useful when you need to enter data into the cells that were combined or want to make a table easier to sort and filter. Do not expect it to split a heading or phrase across the restored cells: the text remains in one cell. If the merged area contained content, review the result and fill the newly available cells as needed.

Merged cells can also make a sheet harder to work with. Sorting a range or maintaining a consistent table structure is simpler when each row follows the same pattern and cells are not merged across records. Use merges sparingly for presentation headings, and keep the actual data area in a regular grid.

Common problems and how to avoid them

The most important precaution is to check the destination cells. A split sends later parts into columns to the right, so content already there may be affected. Before running the command, make sure those cells are empty or that you have saved their contents elsewhere. For a large or important dataset, try the operation on a copy or a few sample rows first.

Unexpected extra columns: The chosen separator may occur more than once in a value. Try a more specific delimiter or clean the source text.
Some rows split differently: Records may use inconsistent punctuation or spacing. Standardize them or handle exceptions separately.
Text appears in the wrong fields: A delimiter may occur inside a name, address, or description. Review those records and avoid assuming that every occurrence marks a boundary.
No useful split appears: Check whether the separator you chose is actually present in the selected cells. A visually similar character may be different, or spacing may be inconsistent.
Values seem to disappear: Undo immediately if the output is wrong, then inspect the neighboring columns and restore any content that was there before.

For repeated or imported data, consistent structure is more important than the specific delimiter. If one row uses a comma and another uses a space for the same boundary, a single split operation may not produce a clean table. Correcting the inconsistent entries before splitting can prevent a lengthy cleanup afterward.

Google Sheets compared with Excel

Google Sheets and Microsoft Excel both offer ways to separate text by a delimiter, but the controls are not identical. In Sheets, the direct menu command is Data > Split text to columns, and the separator control appears on the sheet after you choose it. In Excel for Microsoft 365 on Windows, a common equivalent is Data > Text to Columns, which opens a wizard. The exact steps and available options differ, so instructions for one program should not be assumed to match the other.

The underlying grid limitation is similar: neither program turns one ordinary cell into two independent cells without changing the row-and-column layout. In either application, use separate columns for separate data fields, and use formatting or merges only when the aim is visual presentation. If someone sends you Excel instructions, look for the equivalent task rather than expecting the same menu wording in Sheets.

Frequently Asked Questions

Can I split one Google Sheets cell diagonally?
No. Sheets does not provide a diagonal split that creates two independently editable parts within one cell. You can use neighboring cells and formatting to approximate the appearance, but the data still belongs in separate cells.

Can Split text to columns put each item on a new row?
The command separates text into columns, not rows. If you need one item per row, you will need to rearrange the results after splitting or use another suitable workflow for your data.

Will splitting text delete the original value?
The command distributes the parts across the original cell and cells to its right, so the original combined value is no longer kept as one unchanged entry there. Copy the source first if you need to preserve it, and ensure destination cells do not contain information you need.

How do I split a cell that was merged?
Select the merged area and choose Format > Merge cells > Unmerge. This restores the grid boundaries but does not divide the text among the cells. You must enter or distribute any separate values yourself.

Can I split text using a character that is not listed?
Yes. After choosing Data > Split text to columns, use the separator control’s custom option and enter the character used in your data. Check a sample first, especially if that character might also appear inside a value.

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.