How to Split an Excel Cell Into Two (and What Works)

How-to basics · Updated November 20, 2026

Excel cannot split one worksheet cell into two independent cells the way you can split a cell in a Word table. To get two usable cells, insert a neighboring cell or column; to divide text inside a cell, use Data > Text to Columns. If you only need a visual dividing line, apply a diagonal border. Choose the method that matches what you want to do with the result.

The phrase split a cell can mean a few different things in Excel. This guide covers the practical options in Microsoft Excel for Microsoft 365 on Windows, including how to preserve your data and formatting. Excel for Mac has the same core Text to Columns and cell-insertion features, though ribbon layout and dialogs can look slightly different. Excel for the web also offers many of these commands, but the desktop app is useful if a command is missing from your ribbon.

What You’ll Need

  • A copy of your workbook, especially if the cells contain important data or formatting.
  • A clear idea of whether you want two real cells, text divided into columns, or only a line that makes one cell look divided.
  • For Text to Columns, an empty destination area to the right of the source cell. The command can fill several columns, depending on the separators in the text.

Step-by-Step

  1. Choose what split means for your task. If you need to enter separate values, sort them independently, or refer to them separately in formulas, create separate worksheet cells. If one cell contains a combined value such as a first and last name, divide its contents into neighboring columns. If the goal is only to make a heading look like two sections, use a diagonal border or place the heading in two cells. A border does not create another cell.
  2. Make room before changing the layout. Save a copy of the workbook or duplicate the worksheet by right-clicking its sheet tab and choosing Move or Copy, then selecting Create a copy. Check the cells beside and below the area you plan to change. Inserting cells can move existing entries, while splitting text can overwrite entries in the destination columns. If those cells are occupied, move or copy their contents first.
  3. Create a second real cell beside the original. If the cell is part of a small area and you want a new cell to its right, select the cell immediately to the right of the original. On the Home tab, choose Insert > Insert Cells. In the dialog, select Shift cells right and click OK. Excel adds a blank cell and moves the selected cell and cells to its right over by one position. You can then put one value in the original cell and another in the new one. Check the surrounding rows: this shifts only the selected cells, so it may change the alignment of a table.
  4. Use a full column when the data is tabular. If you need a new field throughout a list, select the column letter where the new field should go, then choose Home > Insert > Insert Sheet Columns. Excel inserts a whole worksheet column and shifts existing columns right. Add a heading to the new column and keep each record aligned across its row. Inserting an entire column is usually safer for a structured table than shifting one isolated cell, because the rows remain consistent.
  5. Divide text that is already combined in one cell. First make sure the columns to the right are empty, then select the cell or range containing the combined text. Choose Data > Text to Columns. In the wizard, choose Delimited if a character such as a comma, space, semicolon, or tab separates the parts. Choose Fixed width if the values are arranged at consistent character positions without a separator. Click Next, select the appropriate delimiter or set the column breaks, and check the preview before continuing.
  6. Set a safe destination and finish the text split. In the final wizard screen, choose a destination cell if you do not want the results to replace the source location. The destination must have enough empty columns for all the pieces. Choose a suitable data format for each preview column if needed, then click Finish. For example, with a cell containing Ana Rivera and a space as the delimiter, the result is Ana in one column and Rivera in the next. If a name has a middle name, the split may produce three columns, so inspect the preview and reserve enough space.
  7. Check and clean up the results. Confirm that every value landed in the intended column and that numbers, dates, and leading zeros were not changed. Text to Columns can interpret content as a number or date, so set a preview column to Text when preserving digits such as an ID number is important. Add or update column headings, widen columns if values are hidden, and remove the original combined column only after verifying the new cells. If the result is wrong, use Undo immediately or restore the backup before making further edits.
  8. Make a cell look divided without changing the grid. Select the cell, open the Home tab, and click the small dialog launcher in the Font group to open Format Cells. On the Border tab, choose one of the diagonal border buttons, set the line style if desired, and click OK. To show two labels, type one label, press Alt+Enter on Windows to start a new line in the same cell, then type the other label. Turn on Wrap Text and adjust row height and column width. On Mac, use Control+Option+Return for a line break in a cell in many Excel versions; if that shortcut does not work on your setup, use the Mac Excel line-break shortcut shown in its Help. A diagonal border and two lines of text are still one cell, so you cannot enter or sort the two labels independently.
  9. Unmerge a cell if merging is blocking your layout. Select the merged cell and choose Home > Merge & Center > Unmerge Cells. The former merged area becomes separate cells again, but Excel keeps the merged cell’s content in the upper-left cell; it does not distribute that content across the restored cells. You can then enter separate values, or use Text to Columns if the upper-left cell contains text separated by a delimiter. Check the rest of the sheet for other merged cells that may affect sorting, filtering, or inserting cells.

Common Mistakes

Expecting a split-cell button. Excel does not offer a command that divides one ordinary cell into two smaller, independent cells. Inserting a cell or column changes the worksheet grid; Text to Columns divides contents; borders only change appearance. Picking the wrong approach can leave you with a layout that looks right but cannot be used as separate data.

Running Text to Columns without checking the cells beside the source. The output spreads across columns and can replace existing content. Always check the destination area first, and specify a different destination in the wizard when needed. A delimiter can also split more than you expect: a space in a full name, for instance, separates middle names as well as first and last names.

Using spaces as a separator when spaces are part of the value. Addresses, product descriptions, and names often contain spaces that should stay together. Use a consistent delimiter such as a comma if the data has one, or choose Fixed width when positions are predictable. Review the preview rather than assuming Excel knows which spaces matter.

Assuming unmerging restores the original cells’ contents. Only the upper-left cell of a merged range retains the displayed value. Other cells are empty after unmerging. Make a copy before unmerging if you need to preserve a complex layout or are unsure which content was stored where.

Tips

  • For lists that will be sorted or filtered, use separate columns with one kind of information per column. For example, keep first name and last name in distinct fields instead of simulating a split with a diagonal line.
  • Use a heading row to explain each new column, and keep the same structure for every record. Consistent columns make later filtering, charting, and formulas easier.
  • If you are splitting several rows, select the full source range before opening Text to Columns. Check that every row uses the same separator; inconsistent data may need to be cleaned first.
  • Use Undo (Ctrl+Z on Windows; Command+Z on Mac) promptly if an insertion or text split produces an unexpected result. Undo is less dependable after you close the workbook or make a long series of later changes, so keep a backup for important edits.
  • When a cell only needs a two-part heading, consider placing the labels in two adjacent cells and formatting their borders. That keeps the labels accessible as separate values without relying on a diagonal line that can be awkward to read.

Troubleshooting

Insert Cells is unavailable or the layout shifts unexpectedly: check whether the worksheet is protected, whether the selected area is part of an Excel table, and whether merged cells are included in the selection. Unprotect the sheet if you have permission, or select a complete table column and use the table’s insert-column option. If a local insertion would break row alignment, undo it and insert a full worksheet column instead.

Text to Columns puts everything in one column: return to the wizard and confirm that Delimited is selected and the correct delimiter checkbox is enabled. If the separator is a character not listed, choose Other and enter it. For fixed-position data, switch to Fixed width and place the breaks in the preview. If there is no consistent pattern, clean the source data before splitting.

The split changes dates, long numbers, or leading zeros: undo the operation, reopen Text to Columns, and set the relevant preview column to Text before finishing. This is especially important for postal codes, account IDs, and other values that look numeric but should not be calculated. Restore from your backup if the original digits have already been converted and cannot be recovered.

The diagonal line does not show two separate fields: that is expected; borders are decorative only. Insert a neighboring cell or divide the content into columns if you need two independent values. If the line appears faint or missing, open Format Cells > Border again, select a visible line style, and check that the cell’s fill or print settings do not obscure it.

Frequently Asked Questions

Can I split a single Excel cell into two cells?
No. Excel’s grid does not divide an individual cell into smaller cells. Insert a neighboring cell or column to create two real cells, or split the text into columns if the cell contains multiple pieces of information.

How do I split one cell into two columns based on a comma?
Select the cell, choose Data > Text to Columns, select Delimited, check Comma, review the preview and choose an empty destination if needed, then click Finish. Make sure the cells to the right can hold the output.

Can Text to Columns split text into rows instead?
Text to Columns places the pieces in separate columns, not separate rows. For a small amount of data, split into columns and then copy the results and use Paste Special > Transpose if you need to turn a horizontal set of cells into a vertical one. Check the destination first so you do not overwrite other data.

Will a diagonal border let me type two separate values?
No. A diagonal border changes how one cell looks; the cell still stores one value. You can put two lines of text in it for a visual heading, but use separate cells when the values need to be sorted, filtered, or referenced independently.

What happens to the text when I unmerge cells?
The text remains in the upper-left cell of the former merged range. The other cells become blank. Unmerging does not divide the text or distribute it across cells, so use Text to Columns separately if the text has a suitable delimiter.

Does the method differ in Excel for Mac or the web?
The basic options are similar: insert cells or columns, use Text to Columns, or format a border. Ribbon placement and dialog details can vary by platform and update. On Mac, look for the commands on the Home or Data tab; in Excel for the web, use the ribbon search or command search if a button is not immediately visible.

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.