Excel Keyboard Shortcut to Split a Cell

In Excel for Microsoft 365 on Windows, press Alt, H, M, U to unmerge a selected merged cell. Excel has no single command that divides an ordinary cell into smaller cells: to separate text into columns, use Alt, A, E to open Text to Columns, or choose another method depending on what you mean by split.

The shortcut and what it does

Alt, H, M, U is a sequence of ribbon access keys, not a combination to hold down all at once. Select a merged cell, press and release Alt, then press H, M, and U in order. The sequence follows the Windows ribbon path Home > Merge & Center > Unmerge Cells. It removes the merge and restores the individual cells in the selected range.

That command only reverses a merge. It does not divide the text inside a cell, insert a new row or column, or create a custom boundary inside one cell. Excel’s grid is made from rows and columns, so a cell cannot be subdivided like a cell in a Word table. The best method depends on whether you want to restore merged cells or separate the contents of a cell.

Unmerge cells without losing the grid

To unmerge with the mouse, select the merged area and choose Home > Merge & Center > Unmerge Cells. The menu button may display a different merge option depending on the selection; open its dropdown to find Unmerge Cells. You can also use the shortcut above when the ribbon is available.

Unmerging restores the original rows and columns, but it does not copy the merged cell’s value into every restored cell. Excel keeps the value in the upper-left cell of the merged range; the other cells become blank. For example, if B2:D2 were merged and displayed the heading Quarterly Sales, unmerging leaves that heading in B2 and makes C2 and D2 blank.

If you need the heading in each cell, fill the restored cells after unmerging. Select the cells, type the value, then press Ctrl+Enter to enter it in all selected cells. Alternatively, copy the upper-left cell and paste into the other cells. Check first whether any data was already in the range: merging cells can leave only the upper-left value, so unmerging cannot recover values that were discarded when the cells were merged.

Split text across columns with Text to Columns

If by split cell you mean separating words or values stored together, use Text to Columns. Select the source column, then press Alt, A, E on Windows. In the wizard, choose Delimited when a character such as a comma, space, tab, or semicolon marks the boundary. Choose Fixed width when the values line up at consistent positions instead. Review the preview, select the appropriate delimiter or break positions, and finish the wizard.

For example, suppose A2 contains Chen, Mira and A3 contains Patel, Arun. With column A selected, choose Delimited and select comma. The output separates each name into adjacent columns. If the space after the comma remains at the start of the second value, select the option to treat consecutive delimiters as one only when appropriate, or clean up the resulting text afterward; that option treats repeated delimiters as a single boundary and can change results when empty fields matter.

Choose a destination if you want to preserve the original values. If you leave the destination as the selected source column, the results can replace data to its right. Make sure the cells where the split results will go are empty, or move the output to an unused area. Text to Columns changes the existing data rather than inserting new worksheet columns automatically.

Choose a method for the result you need

Before acting, identify whether the task is about cell layout or cell content. These common cases call for different tools:

A merged heading needs to return to separate grid cells: use Unmerge Cells.
A full name, address, or code needs separating at a delimiter: use Text to Columns for a one-time split.
You want a live split that updates when the source changes: use a formula such as TEXTSPLIT in a supported version.
You want to divide a worksheet into more fields: insert worksheet columns; a cell cannot have its own internal columns.

For a dynamic result in Microsoft 365 or Excel 2024, TEXTSPLIT can split text into cells with a formula. With the text Chen,Mira in A2, enter =TEXTSPLIT(A2,",") in B2. It returns Chen in B2 and Mira in C2, spilling into the next cell when the space is available. If those spill cells are occupied, Excel shows a spill error; clear the obstruction or choose another starting cell. Unlike Text to Columns, the formula can recalculate when A2 changes.

Protect data and formatting while splitting

Text to Columns can interpret values as numbers or dates, which may alter how they appear or are stored. A code such as 00427 may lose its leading zeros if Excel treats it as a number. In the wizard, select the output column in the preview and set its data format to Text when the characters must be preserved exactly. This is especially useful for product codes, postal codes, and identifiers that look numeric but are not quantities.

Dates and values containing separators also need care. A comma-separated list may not split correctly if commas appear inside quoted text, and a date can be reinterpreted according to regional settings. Check the preview before finishing and inspect the output afterward. If the original matters, make a copy of the column or workbook first; this is a simple safeguard before a transformation that may overwrite data.

Common problems and quick fixes

The shortcut does not work: press and release each key in sequence, and confirm Excel is the active window. Ribbon access keys can vary if a different language or customized ribbon is in use; use the visible Home menu as a fallback.
Unmerge Cells is unavailable: the selected range may not contain a merged cell. Check the Merge & Center dropdown, and select the merged area rather than an unrelated cell.
The split output overwrites neighboring data: cancel or undo immediately if possible, then repeat with an empty destination column. For an important workbook, work on a copy.
Text to Columns splits at the wrong places: revisit the delimiter choice and preview. If the text uses a separator in some values but not others, a simple delimiter split may not match the intended structure.
A formula result cannot spill: clear cells blocking the expected output, including cells that look empty but contain spaces or formulas returning an empty string.

Windows, Mac, and Excel for the web

The Alt-key sequences in this guide are for Excel on Windows. In Excel for Mac, use Home > Merge & Center > Unmerge Cells for a merged range, or open Data > Text to Columns to separate text. The Windows Alt access-key sequences are not the Mac equivalents; Mac keyboard navigation can also depend on macOS and Excel settings, so the ribbon path is the dependable instruction.

Excel for the web also provides merge controls and text-splitting options through its ribbon, but keyboard access keys may differ from the Windows desktop sequence and can be affected by the browser. If a sequence does not open the intended command, use the on-screen ribbon command. The key distinction remains the same: unmerge for a merged range, and split text for values contained in a cell.

Frequently Asked Questions

What is the keyboard shortcut to split a merged cell in Excel?
On Windows, select the merged cell and press Alt, H, M, U in sequence. This runs Unmerge Cells; it does not split text into separate columns.

Can I split one Excel cell into two cells?
Not as an independent subdivision inside the cell. You can unmerge a merged range, insert worksheet columns, or split the cell’s contents across neighboring cells with Text to Columns or a formula.

How do I split text in Excel without overwriting the original?
Use Text to Columns and set a destination in an empty area, or copy the source column first. A TEXTSPLIT formula placed in another column also leaves the source value intact.

Does unmerging fill the value into every cell?
No. Excel retains the value in the upper-left cell of the merged range and leaves the other cells blank. Copy or fill the value into those cells separately if that is what you need.

What is the Mac shortcut to unmerge cells?
The Windows Alt, H, M, U sequence is not the Mac equivalent. On Mac, select the range and use Home > Merge & Center > Unmerge Cells.

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.