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

How-to basics · Updated November 21, 2026

To split the contents of a cell into two parts in Excel, select the cell or column and choose Data > Text to Columns, then specify the separator between the parts. Excel cannot divide one ordinary worksheet cell into two smaller cells; instead, it puts the pieces into neighboring cells. If you mean a merged cell, you can unmerge it.

The steps below are for Microsoft Excel for Microsoft 365 on Windows. They cover the quick Text to Columns method, a formula option that updates when the source changes, and what to do if you meant a merged cell or a visual layout.

What You’ll Need

  • A workbook with the text or value you want to separate.
  • Enough empty cells to the right of the source, or another blank destination. Splitting one value into two pieces requires two output cells; some splits produce more than two.
  • A clear separator, such as a comma, space, hyphen, slash, or a consistent character between the pieces. If there is no separator, you can use a fixed-width split or Flash Fill instead.
  • If you plan to use the formula method, Microsoft 365 or Excel 2024. TEXTSPLIT is not available in older Excel versions such as Excel 2019 or 2016.

Step-by-Step

  1. Check what kind of split you need. If a cell contains two pieces of text, such as a first and last name or a city and postal code, split the contents into adjacent cells. If the cell is merged across several columns, unmerge it instead. If you only want the sheet to look divided, use borders or adjust the layout; Excel does not have a command to cut a normal cell into two independently editable cells.

  2. Make room for the results. Look at the cells to the right of the source. If the source is A2 and you expect two pieces, B2 must be empty. If you are splitting many rows, check the full output area, not just the first row. Move existing data, or use a blank destination farther across the sheet. You can copy the source column first if you want to keep an untouched version.

  3. Select the source cell or range. Click one cell to split just that entry. To split a list, select the whole range containing the entries, for example A2:A100, and make sure each row uses the same separator pattern. Do not select the blank destination cells as part of the source range.

  4. Open the Text to Columns wizard. On the ribbon, choose Data > Text to Columns. In the first screen, choose Delimited if a character such as a comma or space separates the parts. Choose Fixed width if every entry should be cut at the same character position. Select Next.

  5. Choose the delimiter for a delimited split. Tick the matching option, such as Comma, Space, Semicolon, or Tab. For a separator not listed, tick Other and type the character in its box. The preview shows where Excel intends to split. For example, if A2 contains West, 482, selecting Comma separates West from 482. The comma is removed from the result.

    If a comma is followed by a space, the second result may begin with a space. You can select Space as well, but be careful: choosing both comma and space treats either character as a split point, which can create extra columns if names or phrases contain spaces. Use the preview to confirm the split points before continuing. The option to treat consecutive delimiters as one is useful when repeated separators should count as a single break.

  6. Set the output format and destination. In the wizard’s final screen, review the preview and select each output column if it needs a specific format. Choose Text for values such as product codes, phone numbers, or postal codes that may begin with zero. Otherwise, Excel may interpret a piece as a number and remove leading zeros. In Destination, keep the original location to put the first result in the source column, or enter a blank starting cell such as $B$2 to preserve the original. Confirm the destination and choose Finish.

  7. Use Fixed width only when the cut position is consistent. In the wizard, choose Fixed width, then click the preview ruler where each break belongs. Drag a break line to reposition it, or double-click a line to remove it. This works for consistently formatted data, such as codes where the first four characters are always one part. It is unsuitable for names or descriptions with variable lengths. Review every preview row before selecting Finish.

  8. Use a formula if the source may change. With the complete text in A2 and a comma separating the two parts, enter this formula in an empty cell:

    =TEXTSPLIT(A2,",")

    For that layout, the formula spills the text before and after the comma into neighboring cells on the same row. If A2 contains West,482, the results are West and 482. To include a space as part of the separator, and the source consistently uses comma-space, use =TEXTSPLIT(A2,", ") instead. Leave the cells to the right of the formula empty so Excel can display the spilled results. Unlike Text to Columns, the formula recalculates when A2 changes.

  9. Check the results and save. Compare a few split rows with the original, especially the first and last entries. Confirm that no values were overwritten, that leading zeros remain where needed, and that the pieces landed in the intended columns. If Text to Columns made an unwanted change, press Ctrl+Z immediately on Windows to undo it; on a Mac, use Command+Z. Save the workbook once the results look right.

For Excel for Mac, the Data tab also provides Text to Columns, though the wizard’s position and appearance can differ slightly. Excel for the web has Text to Columns in many current accounts; if you do not see the command, open the workbook in desktop Excel or use TEXTSPLIT if your account supports it.

Common Mistakes

  • Expecting the cell itself to divide. Splitting text creates separate values in separate cells; it does not change the worksheet grid. Plan to use an adjacent column or a blank destination.
  • Overwriting existing data. Text to Columns can place results over neighboring values. Check every destination column for the full selected range before finishing, or choose a blank destination.
  • Choosing the wrong delimiter. If you select Space for a full-name list, Excel can split middle names as well as first and last names. Check the preview and select a separator that actually marks the boundary you want.
  • Letting Excel convert text to numbers or dates. Codes like 0047 can become 47, and date-like text may be reinterpreted. Set the affected output column to Text in the wizard or check the results carefully.
  • Using Text to Columns when you need an updating split. It produces values, not a live link to the source. Use TEXTSPLIT in a supported version when the source is expected to change.

Tips

  • Keep a copy of the original column until you have checked the results. This makes it easier to compare or repeat the split with a different delimiter.
  • Use the preview in Text to Columns as a test. If one row splits differently from the rest, cancel and handle the exceptions before processing the whole range.
  • For a large range, select the entire set of source rows at once. Excel applies the selected delimiter or fixed-width breaks to each row, so consistent formatting matters.
  • If the split pieces need to stay in the same workbook as formulas, leave the original column intact and put the formula in an empty column. If you later need fixed values, copy the formula results and use Paste Special > Values.
  • When there is no separator, consider Flash Fill: type the desired first result in the neighboring column, start the next example, and choose Data > Flash Fill if Excel offers the matching pattern. Review the filled results because Flash Fill recognizes a pattern rather than applying a guaranteed delimiter rule.
  • If you only need a visual divider, apply a border between columns or resize the columns. That changes the appearance without changing the data into separate values.

Troubleshooting

  • The results do not appear or Excel warns about overwriting cells: Clear the cells where the split output would go, or choose a blank Destination in the wizard. Remember that one source value can create more than two outputs if the delimiter occurs several times.
  • Everything stays in one column: Reopen Text to Columns and verify that you chose Delimited, selected the actual character used in the source, and can see the break in the preview. A hyphen and an en dash look similar but are different characters.
  • The output has unwanted extra columns: A delimiter may occur inside the text, or you may have selected more than one delimiter. For example, selecting both comma and space can split a phrase at every space. Cancel or undo, then use only the intended separator and inspect the preview.
  • The second piece has an extra space: The source may contain a space after the delimiter. You can select the exact combined delimiter in the wizard where possible, adjust the source text first, or use the comma-space version of TEXTSPLIT when that is the consistent pattern.
  • Leading zeros disappeared or values changed: Undo the operation if possible, then repeat it and set the affected output column to Text in the final wizard screen. If the original has already been replaced and no copy exists, recover the values from a backup or the source data; changing the format afterward cannot restore zeros that were discarded.
  • TEXTSPLIT returns #SPILL!: Clear the cells where the formula’s results need to appear, including any merged cells in that output area. The formula cannot spill into cells that already contain content.
  • TEXTSPLIT shows #NAME?: Your Excel version may not include the function, or the function name may be misspelled. Use Text to Columns in desktop Excel, or check whether Microsoft 365 or Excel 2024 is available.
  • You meant to divide a merged cell: Select it and choose Home > Merge & Center > Unmerge Cells. The value remains in the upper-left cell of the former merged range; the other cells become separate blank cells.

Frequently Asked Questions

Can I split one Excel cell into two actual cells?

Not directly. Excel’s grid does not let you subdivide a single ordinary cell. You can split its contents into neighboring cells with Text to Columns or a formula, or use a layout workaround with adjacent cells.

How do I split a cell at a space?

Select the source, choose Data > Text to Columns, select Delimited, tick Space, and check the preview. If the text contains other spaces that should stay together, choose a different delimiter or use a more specific method.

How do I split a cell into first and last names?

If every entry has exactly one space between the two names, Text to Columns with Space can separate them. Entries with middle names or compound surnames need a more deliberate rule, because a space alone does not identify which name boundary you mean.

Will splitting a cell change the original data?

Text to Columns normally writes its first result in the source location, so it can replace the original text. Choose a blank Destination or copy the source column first to keep an original. A TEXTSPLIT formula leaves the source cell unchanged.

Can I split a merged cell into two?

You can unmerge a merged range using Home > Merge & Center > Unmerge Cells. This restores the underlying cells, but it does not divide the original value; that value stays in the upper-left cell.

Why does Excel split one entry into too many pieces?

The chosen delimiter may appear more than once in the text. Check the preview, remove extra delimiters from the selection, or clean the entries so the separator appears only where the intended boundary belongs.

Related

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.