Split Cells in Google Sheets: Shortcut and Steps

Google Sheets has no dedicated keyboard shortcut for splitting a cell’s text into columns. The direct method is to select the cell or range, choose Data > Split text to columns, and pick a separator; for a repeatable, formula-based split, use the SPLIT function.

What “Splitting Cells” Means in Sheets

People use “split cells” to describe two different tasks. The first is dividing text stored in one cell into separate cells—for example, turning “Mina Patel” into a first-name cell and a last-name cell. Google Sheets can do this with its Split text to columns command or with a formula. The second meaning is dividing one grid cell into smaller grid cells, as if a cell could be cut in half. Sheets does not provide that kind of cell-splitting operation. A cell is already the smallest unit in the grid; instead, you can insert rows or columns, or distribute text across neighboring cells.

This distinction matters when following instructions from another spreadsheet program. If a guide says “split a cell,” check whether it means separate the text or change the grid. The Sheets command discussed here separates text, not the underlying cell structure.

Split Text to Columns with the Menu

For a one-time cleanup, the menu command is usually the simplest choice. It works with one cell or a selected range and places the pieces into adjacent columns.

Select the cell or cells containing the text. For example, select A2:A20 if each row contains a combined name.
Choose Data > Split text to columns.
Use the separator control that appears near the selected data. Choose a suggested separator such as comma, space, or semicolon, or select a custom separator and enter the character used in your data.
Check the resulting columns. If the split is not what you intended, use Undo immediately and choose a different separator.

Suppose A2 contains Mina,Patel,Sales. Selecting A2, choosing the comma separator, and applying the command puts “Mina,” “Patel,” and “Sales” into neighboring cells on that row. The command changes the selected text into separate cell values; it does not create a formula that stays linked to the original text.

Before running it, check the cells to the right of the source range. The split results need room to spread across columns, so clear any existing values in the expected destination area or move them elsewhere. Also consider making a copy of the sheet or using Undo if the data is important. For a large range, test the operation on a few representative rows first.

Use the Menu Search Shortcut

Although there is no dedicated “split text to columns” key combination, Google Sheets includes a menu-search feature that can make the command quicker to reach. On many Windows or ChromeOS keyboards, press Alt+/ to search menus, type “Split text to columns,” and choose the matching command. On a Mac, the corresponding key is commonly Option+/. Keyboard behavior can vary with the browser, operating system, and keyboard layout, so if the key does not open menu search, use the Data menu instead.

This is a way to find and run a menu command, not a special split shortcut. It may save a few clicks, but it does not change how the operation works or which separator is used. If you need a dedicated key sequence for repeated work, Sheets does not offer a built-in shortcut assignment for this command. A formula or a carefully designed workflow may be more practical.

Choosing a Separator

The separator is the character or boundary Sheets uses to decide where one piece ends and the next begins. The right choice depends on how the source text was created, not just on what the text looks like.

Comma: Useful for values such as Ravi,Chen,Support, provided commas do not also appear inside a field.
Space: Can separate a simple first and last name, but names with middle names, multiple-word surnames, or extra spaces can produce more columns than expected.
Tab: Often appropriate when text was copied from a tab-separated list or another table.
Custom character: A pipe (|), slash, or other consistent marker can be safer when ordinary punctuation or spaces occur inside the values.

For example, splitting Jordan Lee, North District on every space would break the name and the district into several pieces. Splitting on the comma preserves the spaces within each field. However, if a field itself contains a comma—such as a quoted address—simple delimiter splitting may not understand that the comma is part of the value. Inspect the source format before choosing a separator, and do not assume that a visible comma always marks a boundary.

Use SPLIT for Repeatable Results

The SPLIT function is useful when the original text may change or when you want to keep a derived result alongside its source. It returns pieces in neighboring cells, so make sure the cells to the right of the formula are empty. The output updates when the referenced text changes.

With the text Mina,Patel,Sales in A2, enter this in B2:

=SPLIT(A2,",")

The result is “Mina” in B2, “Patel” in C2, and “Sales” in D2. The formula splits at each comma. If your source has a space after each comma, the results may retain leading spaces, depending on the text. You can clean those values separately or standardize the source before splitting.

SPLIT also has optional settings. With the text red::blue::green in A2, the following formula in B2 treats the two-character string :: as one separator rather than treating each colon as an independent separator:

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

That returns “red,” “blue,” and “green” across B2:D2. By default, the function can treat each character in a multi-character delimiter as a separate separator; the third argument set to FALSE tells it to match the delimiter as a whole. A fourth optional argument controls whether empty results are removed. This is useful when repeated separators might represent blank fields, so check the function’s behavior against your data before relying on column positions.

To use the same pattern for multiple rows, enter the formula for each corresponding source row, or copy it down. Each formula must have enough empty cells to its right for the returned pieces. A formula is preferable when the source is maintained over time; the menu command is often more convenient when you want to convert a fixed range into ordinary values.

Common Problems and How to Fix Them

Everything remains in one column: The selected separator may not match the data. Undo, then choose the actual delimiter or enter it as a custom separator.
Values appear in extra columns: The chosen character may occur inside the fields, or a space-based split may be breaking multiword values. Try a less common delimiter or a formula with more deliberate rules.
Some rows split differently: The source values may not follow one consistent pattern. Look for missing separators, extra spaces, or alternate punctuation before applying the operation to the full range.
Formula output does not appear: Check that the cells where the results need to spill are empty. Existing content can prevent an array result from expanding.
A split date or number looks different: Sheets may interpret a piece as a date or number and display it using the cell’s formatting. Check the underlying value and formatting, or set the destination cells to plain text before splitting when preserving literal characters is important.

One easy misconception is that choosing “space” separates only the first space. A delimiter-based split can produce a piece at each matching boundary, so a name containing multiple spaces may create several outputs. Another is that the menu operation is automatically reversible later. You can use Undo directly after a change, but once you make additional edits or close the file, it is safer to rely on version history or a saved copy than to assume the original text can be reconstructed exactly.

Menu Tool or Formula?

Use the menu command when the data is a one-time import, the separator is consistent, and you want fixed values in the sheet. Use SPLIT when the source values may change, when you need the result to recalculate, or when you want to keep the original and the separated output visible together. The formula is also easier to review later because the cell shows the rule used to separate the text.

Neither approach automatically handles every complicated text format. If fields contain the same punctuation used as the delimiter, or if rows have inconsistent structures, inspect the data and consider a more specialized cleanup process rather than applying a broad split and assuming the columns are correct. For an especially important list, retain an untouched source column and verify several results after splitting.

Excel has a similarly named Text to Columns feature, but its menu path and dialog differ from Google Sheets. The Google Sheets route here is Data > Split text to columns; Excel-specific instructions and shortcuts should not be assumed to work in Sheets.

Frequently Asked Questions

What is the shortcut to split cells in Google Sheets?
There is no dedicated keyboard shortcut for Split text to columns. Use Data > Split text to columns, or use the menu-search key combination, commonly Alt+/ on Windows or ChromeOS and Option+/ on Mac, to find the command.

Can Google Sheets split one cell into two cells?
It can split the text in a cell into two or more neighboring cells when the text has a consistent separator. It cannot divide one grid cell into smaller grid cells.

How do I split a full name into first and last names?
If every name contains exactly one space, select the names and choose Data > Split text to columns, then choose space. Names with middle names or multiword surnames need a more careful method because a space split may create extra columns.

Will Split text to columns update when the original cell changes?
No. The menu command writes split values into cells. Use a SPLIT formula if you want the separated results to recalculate when the source text changes.

Why can’t my SPLIT formula expand?
The formula needs open cells to the right for its results. Clear obstructing content, or move the formula to a spot with enough empty columns.

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.