How to Split a Cell in Google Sheets: Text and Data

To split text in a Google Sheets cell into separate columns, select the cell or range, then choose Data > Split text to columns and pick a delimiter, such as a comma or space. If you mean dividing one spreadsheet cell into smaller grid cells, Sheets does not do that: instead, split its contents across neighboring cells or insert rows and columns around it.

What splitting a cell means in Google Sheets

In everyday spreadsheet use, “split a cell” usually means separating the text stored in one cell into parts. For example, a cell containing Jordan Kim, Denver can become one cell for the name and another for the city. Google Sheets places the pieces in adjacent columns; it does not carve the original cell into smaller portions.

This distinction matters because spreadsheet cells belong to a grid. You can add columns or rows to change the grid, and you can merge cells, but you cannot split one individual grid cell into independently sized cells while leaving the surrounding grid unchanged. If your goal is to separate information for sorting, filtering, or calculations, split the text into neighboring cells. If your goal is simply to make a heading look divided, consider using separate columns or rows and formatting them to suit the layout.

Split text into columns with the menu

The menu method is best when you want to separate existing text once and inspect the results directly. Use Google Sheets in a web browser and follow these steps:

Select the cell or cells that contain the text you want to separate. You can select a range in one column if the entries follow the same pattern.
Choose Data > Split text to columns.
In the separator control that appears, choose a delimiter such as Comma, Space, or Semicolon. Choose Detect automatically if you want Sheets to try to identify the separator, or choose Custom and enter the character or text that divides your values.
Check the resulting columns. If the separation is not right, change the delimiter or undo the operation and try again.

For example, suppose A2 contains Jordan Kim, Denver, CO. Selecting A2 and choosing a comma delimiter separates the entry at each comma, giving you Jordan Kim, Denver, and CO in neighboring cells. The comma is removed from the separated values.

Before using this method, make sure the cells to the right of the selected data are available. The separated pieces need room to spill into adjacent columns, and existing content in that area can be affected. For a large range, test the operation on a copy or a few sample rows first.

Choose a delimiter that matches your data

A delimiter is the character or text that marks the boundary between parts. The right choice depends on how the source data was written, not on what you want the new columns to be called.

Comma: Useful for entries such as Item, Quantity, Price, provided commas are not also used inside a field.
Space: Can separate simple first-and-last-name pairs, but may produce extra columns for middle names or multiword surnames.
Semicolon or tab: Often useful for copied or exported data that uses those characters to separate fields.
Custom: Helpful when a consistent mark such as a slash, pipe, or label separates the parts.
Detect automatically: A convenient starting point, but check the output; automatic detection may not match an unusual or inconsistent pattern.

Be cautious with punctuation that can also appear within a value. A comma-separated address field, for instance, may contain several commas and split into more pieces than intended. A delimiter that appears only between the fields is safer. If the source has inconsistent separators, clean or standardize the text first, or use a formula designed for the exact pattern.

Use the SPLIT formula for results that update

The SPLIT function is useful when you want the separated values to update automatically if the original text changes. It returns the pieces into neighboring cells, so leave enough empty space to the right of the formula cell. If those destination cells are occupied, Sheets cannot expand the result there.

With the text Jordan Kim, Denver, CO in A2, enter this formula in B2 to split at commas:

=SPLIT(A2, ",")

The result fills B2, C2, and D2 with Jordan Kim, Denver, and CO. The original text remains in A2. This is different from the menu operation, which separates the selected contents in place. In some spreadsheet locales, argument separators in formulas are configured differently; if Sheets rejects a formula with commas between arguments, check the spreadsheet’s locale settings.

SPLIT also accepts optional settings. By default, it treats each character in the delimiter argument as a possible separator and removes empty pieces. If you need the entire delimiter string to be treated as one unit, set the third argument to FALSE. For example, with Order - 482 in A2, this formula in B2 splits on the full space-hyphen-space sequence:

=SPLIT(A2, " - ", FALSE)

It returns Order in B2 and 482 in C2. Without FALSE, the spaces and hyphen could each be treated as delimiters, which can create unwanted or empty pieces. The fourth argument controls whether empty results are removed; by default, empty pieces are removed. Set it to FALSE when keeping empty positions between repeated delimiters is important.

Work through common examples

For a simple name field, choose a space delimiter only if each entry reliably contains two words. If some people have middle names, a space split may put first, middle, and last names into three columns for those records, while two-word entries use only two. That may be acceptable if you plan to review the results, but it is not a dependable way to identify first and last names in a varied list.

For a text value such as SKU-1048, use a hyphen delimiter to separate the label from the number. For a web address or file path, splitting on a slash can produce several parts because the character may appear more than once. In each case, preview the pattern and decide whether every occurrence should create a boundary.

For repeated records, select the full range rather than processing one cell at a time, but first confirm that every row uses the same delimiter and similar structure. A few inconsistent rows can shift data into different columns, making later sorting or analysis confusing.

What splitting does not do

Splitting text does not automatically understand meaning. A comma is just a delimiter: Sheets will not know whether it separates a city from a state or is part of a quoted address. The result depends on the separator and the text pattern. Review the output before relying on it for reports or calculations.

The operation also creates columns, not rows. If a cell contains a list and you need one item per row, splitting to columns is not the same as splitting into rows. You can separate the values into columns first and then rearrange them using appropriate copy-and-paste or formula techniques, but choose a method based on the desired layout. Likewise, splitting does not automatically trim every extra space or correct inconsistent spelling. Check the resulting values and clean them as needed.

Formatting is separate from the text operation. After splitting, you may need to resize columns, apply number formats, or add headings. Text that looks like a date or number may not be interpreted the way you expect, so verify the cell values before using them in calculations.

Fix common problems

Everything stays together: Check that the delimiter you chose actually appears in the text. A hyphen is different from an en dash, and a regular space is different from some other whitespace characters.
Values split into too many pieces: The delimiter may appear inside the values. Try a more specific custom delimiter or use a formula that matches the exact separator.
There are unexpected blanks: Repeated delimiters can create empty positions. With SPLIT, review the optional setting for removing empty text, and check whether the source contains consecutive separators.
The formula shows an expansion error: Clear the cells where the results need to appear. A formula that returns multiple values needs an unobstructed area to its right.
Some rows look misaligned: The entries may not share a consistent structure. Test a sample, identify exceptions, and handle them separately rather than assuming one delimiter fits every row.
Original data seems to have changed: The menu operation works on selected content. Keep a copy of important source data or use a formula in a separate column when you want to preserve the original.

Choose between the menu and a formula

Use Data > Split text to columns for a quick, one-time separation when you are comfortable changing the selected data. It is easy to apply to a range and makes the output visible immediately. Use SPLIT when the source may change, when you want to keep it intact, or when you need the output to recalculate. A formula is also easier to copy down a table, as long as each row follows a compatible pattern and the result area is clear.

Neither method is automatically better. If you are preparing a clean dataset once, the menu is straightforward. If the source is regularly refreshed, a formula can reduce repeated manual work. For important data, duplicate the sheet or preserve the original column before making a bulk change.

How Google Sheets differs from Excel

In Google Sheets, the browser menu path is Data > Split text to columns, and the formula used above is Sheets’ SPLIT function. Excel has its own text-splitting tools and functions, so menu names and formulas are not interchangeable in every version. If you are following instructions written for Excel, do not assume that the same ribbon path or function name applies in Sheets. For this task in Sheets, use the menu or function described here.

Frequently Asked Questions

Can I split one Google Sheets cell into two actual cells?
No. You cannot divide one grid cell into smaller independent cells. You can split the text it contains into adjacent cells, or change the surrounding grid by inserting rows or columns.

How do I split a cell by a comma?
Select the cell or range, choose Data > Split text to columns, and select Comma. For a formula-based result, put the text in A2 and enter =SPLIT(A2, ",") in an empty cell.

Can I split text into rows instead of columns?
The Split text to columns command creates columns. It does not directly put each separated item on a new row; use a separate rearrangement method if rows are the required layout.

Will splitting change my original cell?
The menu command separates the selected cell contents into neighboring columns. A SPLIT formula leaves the source text in place and displays its results elsewhere. Preserve a copy before a bulk menu operation if the source matters.

Why does SPLIT put the results in the wrong columns?
Check whether the delimiter appears inside a value, whether the source rows use different patterns, and whether a multi-character delimiter is being treated as separate characters. Adjust the delimiter or use the optional settings in the formula.

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.