Split a Cell in Excel: Text to Columns, Formulas, and More

Yes. In Microsoft Excel, select the cells and choose Data > Text to Columns to split their contents using a delimiter such as a comma, space, or tab. If you meant Google Sheets, it has a separate Data > Split text to columns command; the two spreadsheet apps do not share the same menu.

The right method depends on whether you want a one-time change, a result that updates when the original text changes, or a split that runs down rows instead of across columns. The steps below focus on Excel for Microsoft 365 on Windows, with notes about other versions and Google Sheets.

What “split a cell” means in Excel

Excel does not divide one cell into smaller cells while keeping the surrounding grid intact. Instead, it separates the text or values inside a cell and puts the pieces into neighboring cells. For example, splitting Maya Chen, Seattle, 98101 at each comma produces three cells in the same row: one for the name, one for the city, and one for the postal code.

This distinction matters because cells to the right of the source may already contain data. A split can place results over that data, so check the destination area first. You can insert blank columns before splitting if needed. Also, a value that looks like several fields may actually be a single text string; Excel needs a consistent separator or a predictable character position to know where one part ends and the next begins.

There are three common approaches:

Text to Columns: a built-in wizard for a one-time split by delimiters or character positions.
Formulas: useful when the source may change and the separated results should update.
Flash Fill: useful when you can show Excel a recognizable example of the desired pattern.

Split a cell with Text to Columns

For a list such as names separated by commas, Text to Columns is usually the most direct choice. It changes the selected data into separate columns rather than creating a live connection to the original text.

Make a copy of the source column or confirm that the cells to its right are empty.
Select the cells you want to split. If you select a whole column, Excel can process each populated row in that column.
Choose Data > Text to Columns.
In the wizard, choose Delimited if a character such as a comma or tab separates the fields. Choose Fixed width if the fields begin at consistent character positions.
For a delimited split, select the delimiter, such as Comma, Tab, Semicolon, Space, or Other. Check the preview to confirm the breaks are in the right places.
Choose a destination if you do not want the results to start in the source column, then complete the wizard.

The Data tab and Text to Columns command are also available in current Excel for Mac desktop versions, although the layout of the ribbon or wizard can look different. Excel for the web may not provide the same full wizard experience in every account or release; when the command is unavailable, use a supported formula or open the workbook in desktop Excel.

Text to Columns is a conversion, not a continuing rule. If the source changes later, the separated cells do not automatically recompute. For regularly updated data, use a formula or repeat the conversion after refreshing the source.

Choose the right delimiter and data type

A delimiter is the character, or group of characters, marking the boundary between fields. Commas often separate exported values, tabs commonly separate copied table data, and semicolons may appear in regional exports. A space can separate first and last names, but it is unreliable when a name contains a middle name, multiple spaces, or a compound surname.

Before confirming a split, inspect the preview and consider these details:

Several delimiters: You can select more than one delimiter when the data uses, for example, both commas and semicolons. Confirm that doing so will not split legitimate text unexpectedly.
Repeated separators: The wizard includes an option to treat consecutive delimiters as one. This can help when fields are separated by variable runs of spaces, but it can also discard an intentionally blank field.
Text qualifiers: Exported data may enclose a field in quotation marks, especially if the field itself contains a comma. The text qualifier setting helps Excel keep that quoted comma inside one field rather than treating it as a boundary.
Column data format: A string such as 00127 may be an ID or postal code, not a number. Set that output column to Text if leading zeros must remain. Dates and long numbers also deserve a preview because automatic conversion can change how data is stored or displayed.

For example, splitting Lee, Jordan, Sales at every comma produces three fields, even if the first two fields together are a person’s name. If the intended result is first name and last name, the source needs a consistent name pattern or a different method; a simple delimiter cannot infer which comma should be ignored.

Split text with a formula that updates

In Microsoft 365 and Excel 2024, the TEXTSPLIT function can return multiple pieces from one cell and spill them into adjacent cells. This is useful for repeatable work: change the source value, and the formula recalculates. The cells where the result needs to spill must be empty.

Assume A2 contains Maya Chen | Seattle | 98101, with the exact separator being a space, vertical bar, and space. Enter this formula in B2:

=TEXTSPLIT(A2," | ")

The result spills across B2:D2 as Maya Chen, Seattle, and 98101. TEXTSPLIT is available in Microsoft 365 and Excel 2024; it is not available in every older perpetual version of Excel. If Excel displays a #NAME? error, check the app version and function availability.

TEXTSPLIT can also split on more than one delimiter. For example, if A2 contains a list separated by commas or semicolons, use:

=TEXTSPLIT(A2,{",",";"})

That formula returns pieces at either delimiter. The curly-brace constant shown uses comma-separated items, as expected in standard English-language Excel formula syntax. Regional settings can affect formula separators, so a workbook configured for a different locale may require its local list separator.

When a split formula seems not to work, check that the separator in the formula exactly matches the text. A comma followed by a space is different from a comma alone. Also check that the cells into which the result would spill are clear; otherwise Excel may show #SPILL!. Formulas are particularly helpful for regularly refreshed data, but they require a version of Excel that supports the functions used.

Split into rows instead of columns

Text to Columns and a basic TEXTSPLIT formula are commonly used to place results across a row. Sometimes the desired layout is vertical—for instance, one cell contains red,blue,green, and each color should occupy a separate row. In Excel 365 or Excel 2024, combine TEXTSPLIT with TRANSPOSE.

Assume A2 contains red,blue,green and you want the three values to appear down column B. Enter this in B2:

=TRANSPOSE(TEXTSPLIT(A2,","))

The formula spills into B2:B4 and returns red, blue, and green, in that order. Keep the cells below B2 empty so the result has room. This remains linked to A2, unlike a one-time conversion. If you need a fixed result instead, you can copy the output and use Paste Special > Values, where available in your Excel version.

Use Flash Fill for pattern-based splits

Flash Fill can recognize a pattern from examples when a simple delimiter is not enough. Suppose A2 contains Maya Chen. In B2, type Maya, the first name you want extracted; then begin typing the next expected first name in B3. If Excel detects the pattern, it offers a preview to fill the remaining cells. Choose the suggestion, or use Data > Flash Fill. In Excel for Windows, Ctrl+E is the Flash Fill shortcut; shortcut behavior can differ on Mac, so use the Data tab there if needed.

Flash Fill is not a formula and does not guarantee a correct interpretation of every row. It may handle a consistent list of two-part names well but fail on entries with middle names, suffixes, or different ordering. Review the output, especially when the data has exceptions. Use Text to Columns for a consistent separator, formulas for a repeatable live result, and Flash Fill when the desired transformation is clear from examples but not captured by one simple delimiter.

Excel and Google Sheets use different commands

The phrase “Google split cell in Excel” can mean either finding a Google search result about Excel or asking how to split data in Google Sheets. They are separate spreadsheet programs, so menu names and feature details differ.

In Google Sheets in a web browser, select the cells and choose Data > Split text to columns. Sheets provides a separator control, including an option to detect a separator automatically. You can also choose a custom separator. In Excel, the comparable one-time tool is Data > Text to Columns. Excel’s wizard also includes a fixed-width option, which splits at chosen character positions rather than at a delimiter.

If you are moving data between the apps, check the results after importing or copying. Dates, leading zeros, quoted text, and regional number formats may be interpreted differently. Formulas available in one product may not be available or behave identically in the other. The basic goal is the same—separate one text value into fields—but instructions for one app should not be assumed to match the other app’s menus.

Common problems and how to fix them

The split overwrote nearby data. The output occupies cells beside the source. Undo immediately if possible, or restore from a copy, then clear space or choose a different destination before repeating the operation.

Some rows split into too many pieces. The chosen delimiter may occur inside a field, such as a comma inside a quoted address. Use the text qualifier setting for quoted data, or choose a delimiter that marks field boundaries reliably.

Blank fields disappear or shift. Consecutive delimiters can represent an empty value, such as two commas in a row. Do not treat consecutive delimiters as one if preserving blank fields matters. Review the preview before completing a conversion.

Leading zeros vanish. Excel may interpret an output as a number. Set the column data format to Text in the wizard when the digits are identifiers, account codes, or postal codes rather than values for arithmetic.

A formula returns an error or will not spill. Confirm that TEXTSPLIT is supported in your Excel version, that the delimiter matches the source exactly, and that output cells are empty. A blocked spill range commonly causes #SPILL!; an unsupported function can cause #NAME?.

Frequently Asked Questions

Can I split one Excel cell into two cells?
Yes. Use Data > Text to Columns and select the delimiter between the two parts, or use a formula such as TEXTSPLIT in a supported version. The result occupies separate neighboring cells; it does not divide the physical cell itself.

How do I split a full name into first and last name?
If every entry has exactly one space between two name parts, split on a space with Text to Columns or TEXTSPLIT. For names containing middle names, compound surnames, or suffixes, a simple space split may create incorrect fields; check the source pattern and review the results.

Can Excel split a cell automatically when I type a delimiter?
Not by default in a normal worksheet cell. Text to Columns is a one-time action, and a formula can update results based on the source. For automatically separated incoming data, consider how it is imported and whether a repeatable formula or data transformation process is appropriate.

Why does Text to Columns put everything in one column?
The selected delimiter may not match the actual character in the source. Check for tabs instead of spaces, semicolons instead of commas, or a space after a comma. The wizard’s preview helps identify the correct setting before you finish.

Is Google Sheets’ Split text to columns the same as Excel’s tool?
They serve a similar purpose, but the commands and options are not identical. Use Data > Split text to columns in Google Sheets, and Data > Text to Columns in Excel. Verify the output when switching between apps, particularly for quoted values and number formats.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.