How to Split a Cell in Google Sheets Into Two Cells

To split text in Google Sheets, select the cell or range, choose Data > Split text to columns, then select the character that separates the parts. For a formula-based split, if the text is in A2 and a comma divides it, enter =SPLIT(A2,",",FALSE,FALSE) in an empty cell; the results spill into neighboring columns.

Choose the right splitting method

Use the menu when you want to separate existing values in place and do not need the result to update from a formula. Use SPLIT when you want results in a separate area that recalculate if the original cell changes. Either method depends on finding a consistent separator, such as a comma, space, hyphen, slash, or tab.

For the menu method, work in a browser and follow these steps:

Select the cell or range containing the combined text.
Choose Data > Split text to columns.
When the separator control appears, choose a separator from its dropdown, or choose a custom separator and enter the character you need.
Check the resulting columns. If the split is wrong, undo it and choose a more suitable separator.

If the menu detects a separator automatically, inspect the result rather than assuming it found the intended boundary. Automatic detection can be convenient for clear, consistently formatted values, but a specific separator gives you more control. Before applying the operation, make sure the cells to the right of the source have room for the results. Save a copy or duplicate the sheet first if the original text must be preserved exactly.

What splitting a cell actually does

A cell can display a phrase such as Jordan Lee, but the phrase is still one text value until you split it. Splitting separates that value at each occurrence of the chosen delimiter and puts the resulting pieces into adjacent columns. For example, splitting Jordan,Lee on a comma gives Jordan in one column and Lee in the next.

The number of output pieces depends on how often the delimiter occurs. If a value contains three commas, splitting on commas can create four pieces, not two. That matters when a destination is intended to have exactly two fields. A name like Lee, Morgan, Jr. has two commas; a simple comma split produces three columns. To divide such a value only at the first comma, use a formula that finds the first occurrence, as described below.

Splitting also does not automatically understand meaning. It cannot reliably know which part is a first name, a surname, a street, or an apartment number. It follows the separator rule you specify. If the same character has different meanings in different rows, review the data and decide on a consistent rule before splitting.

Split with a formula

The Google Sheets SPLIT function returns separate values across columns. With the original text in A2 and the exact comma delimiter between the two parts, put this formula in B2:

Assuming A2 contains Jordan,Lee, enter =SPLIT(A2,",",FALSE,FALSE) in B2. The result is Jordan in B2 and Lee in C2.

The third argument, FALSE, tells Sheets to treat the delimiter as the complete string rather than splitting on each character in it. The fourth argument, also FALSE, keeps empty pieces instead of removing them. For a one-character delimiter, the third argument may not make a visible difference, but specifying both options makes the intended behavior explicit. Because this is a formula, leave the cell to its right empty so the result can expand. If the formula cannot expand into occupied cells, Sheets reports an expansion error.

To use the same pattern for many rows, enter the formula beside the first record and fill it down. Each row will refer to its corresponding source cell if you use a relative reference such as A2. For example, when copied one row down, the reference becomes A3. Formula results remain connected to the source; changing the original value can change the split output.

If a value can contain additional commas but you want to split only at the first one, use two formulas instead. Assuming A2 contains Lee, Morgan, Jr., enter this in B2 to return the text before the first comma:

=LEFT(A2,FIND(",",A2)-1)

With that same layout, enter this in C2 to return everything after the first comma, with leading and trailing spaces removed:

=TRIM(MID(A2,FIND(",",A2)+1,LEN(A2)))

The results are Lee in B2 and Morgan, Jr. in C2. These formulas require a comma to exist in A2: if there is no comma, FIND returns an error. If some rows lack the separator, handle those rows separately or add an error-handling rule suited to the intended output.

Prepare the data and destination cells

A little preparation can prevent a split from damaging other information. The menu operation places pieces in columns beside the source, so inspect that area first. If the next column contains notes, IDs, or another field, move the source data to a clear area or insert enough blank columns before splitting. Do not assume the sheet will preserve unrelated neighboring values.

Keep a backup: Duplicate the sheet or copy the original column to another location if you may need to reverse the transformation later.
Check the whole range: Confirm that the selected cells have the same general structure and delimiter.
Plan for the widest row: Leave enough empty columns for the row with the most delimiter occurrences.
Preserve the source when needed: Use a formula in a different area, or copy the original column before applying the menu command.

For a clean table, add meaningful headers to the new columns after checking the output. If you split a full name into two fields, label them only if the data really follows that pattern. Some names contain middle names, suffixes, or multiple family names, so a two-column result should not automatically be interpreted as first name and last name.

Choose a separator that fits the values

The best separator is one that marks the boundary consistently and does not appear inside either part. A comma works well for values such as West, East when the comma is used only between the fields. A hyphen may work for a code such as AB-204, but it is risky for ordinary text that can contain hyphens. A space is often convenient for simple two-word labels, but it will split every word boundary, not just the boundary you have in mind.

When the separator is not visible, the data may contain a tab, a line break, or repeated spaces. You can select a custom separator in the split control if you know the character. If the values use more than one type of separator, standardize them first or use a formula tailored to the patterns. A visual space can also be a nonbreaking space copied from a web page; it may look ordinary but fail to match a normal space. In that case, clean or replace the character before splitting.

Consider Vancouver, BC as an example. A comma is a useful boundary if the goal is to separate city and province, but the space after the comma may remain at the start of the second piece depending on the chosen method and settings. Check a few results and trim spaces if needed rather than assuming all separators include surrounding whitespace.

Clean spaces, empty values, and inconsistent rows

Extra spaces are among the most common reasons split data looks untidy. A source such as Jordan, Lee includes a space after the comma. Depending on the method and exact delimiter, that space may travel with the second piece. You can choose a delimiter that includes the comma and following space when the pattern is consistent, or clean the resulting values. The TRIM function removes leading and trailing ordinary spaces and reduces repeated spaces between words to one.

Empty parts also need attention. A value like Jordan, has nothing after the comma. A formula using SPLIT with empty-text removal enabled may omit that empty piece, shifting the apparent result. In the example formula above, the fourth argument is FALSE specifically to retain empty pieces. Test values with missing information before applying a formula to a full column.

Inconsistent rows may need different treatment. Some records might use commas, others semicolons, and some might have no delimiter at all. A single split rule cannot reliably resolve all of those cases. You can first standardize the separators with find-and-replace, sort or filter the rows for manual review, or separate exceptional records for individual cleanup. Verify both ordinary and unusual examples before relying on the results for reports or imports.

Menu split versus formula split

The menu is usually the simplest choice for a one-time transformation. It changes the layout into separate cell values without leaving a formula dependency on the original. That is helpful when preparing a file for export or cleaning a fixed list. Its trade-off is that you should protect the source first if you need to retain the combined value.

A formula is useful when incoming values may change, when you want to keep the original column intact, or when you need to repeat the same transformation across rows. It is easier to audit and update, but it occupies cells and depends on the source and delimiter staying consistent. It also needs clear space for the result columns.

Google Sheets is not Excel, even though some spreadsheet ideas overlap. In Excel, the comparable menu feature is Data > Text to Columns; Google Sheets uses Data > Split text to columns. The Google Sheets function SPLIT is not an Excel function. Microsoft 365 and Excel 2024 have TEXTSPLIT for formula-based splitting, but a formula written for one program should not be assumed to work unchanged in the other.

Common problems and practical checks

The result has too many columns: The delimiter appears more than once in at least one value. Use a first-occurrence formula if only the first boundary should count.
Text appears to disappear: Check for empty parts and whether the formula removes empty text. Also inspect the original data before replacing or moving anything.
The formula shows an error: Confirm that the source cell exists, the delimiter matches exactly, and the output cells are clear. A first-occurrence formula also needs the separator to be present.
Spaces remain: Decide whether spaces belong to the delimiter. Otherwise, clean the output with a trimming step.
Only some rows split correctly: The source values likely use inconsistent formatting. Identify the outliers instead of repeatedly applying a rule that fits only the majority.

After splitting, compare a sample of results with their original values, including the longest and messiest entries. If the data will be used for sorting, matching, or analysis, check that each output column contains the kind of value its header promises. A quick visual check is especially important for names, addresses, and codes, where a syntactically successful split can still put information in the wrong field.

Frequently Asked Questions

Can I split one cell into exactly two cells?
Yes, if the text has one clear separator between the two parts. Use Data > Split text to columns or a SPLIT formula. If the separator appears more than once, the split can produce more than two pieces; use a first-occurrence formula when the remainder should stay together.

Does splitting delete the original cell?
The menu operation separates the content into adjacent columns, so preserve a copy first if you need the original combined text. A formula approach leaves the source value in place and displays the split results elsewhere.

Can I split text at a space?
Yes. Choose a space as the separator, but remember that every matching space can create another split. This works for consistently structured two-part values, not necessarily for phrases or names with varying numbers of words.

How do I split text only at the first comma?
Use the LEFT and MID formulas shown above. They return the part before the first comma and the remaining text after it, allowing later commas to remain in the second result.

Can I undo a split?
Immediately after using the menu, use Google Sheets’ Undo command if the result is not what you wanted. If you have continued editing, undo may reverse later changes too, so keeping a duplicate sheet or original copy is the safer way to preserve the starting data.

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.