Excel Split Cells: Did Microsoft Remove the Feature?

No—Excel did not get rid of a command that splits one cell into smaller cells; Excel has never offered that kind of cell-splitting feature. You can split text stored in a cell, divide the worksheet view into panes, or change the layout, but those are different operations.

What “split cells” can mean in Excel

The phrase is confusing because people use it for several different tasks. Someone may want to divide a cell containing “North,West” into two values, make one box in a worksheet look like two boxes, or keep two parts of a worksheet visible while scrolling. Excel has ways to handle each of those needs, but they do not all affect the same thing.

The distinction matters because Excel’s grid is made of cells at the intersections of rows and columns. A cell cannot be subdivided independently of that grid. If you split a cell into two pieces, Excel would need to add a row or column boundary that affects the neighboring cells too. Instead, the program offers tools for separating a cell’s contents, changing the worksheet structure, or splitting the screen into panes.

This is different from Microsoft Word, where a table cell can be split into smaller cells using a table-layout command. Excel’s worksheet cells behave as part of a continuous grid, not as individual containers that can each have their own internal divisions.

Split text into separate columns with Text to Columns

If a cell contains several values separated by commas, spaces, tabs, or another character, the closest built-in equivalent is Text to Columns. It separates the cell’s contents into neighboring columns. It does not divide the original cell visually; it creates separate values in the worksheet grid.

Make sure the columns to the right of the source data are empty, or insert blank columns first. Text to Columns can replace existing contents in its output area.
Select the cells containing the text you want to separate.
On Windows, choose Data > Text to Columns.
Choose Delimited if a character such as a comma or tab separates the values. Choose Fixed width if the values are divided by consistent character positions.
Follow the wizard to choose the delimiter, review the preview, and set the destination if you do not want the results to start in the selected range.
Select Finish to place the separated values in the worksheet.

For example, a cell containing North,West can become “North” in one column and “West” in the next. If the source is a list of full names separated by spaces, test the preview carefully: a space delimiter may split a multiword surname into more pieces than you intended. Text to Columns is also available in Excel for Mac, though dialog details can differ by release. Excel for the web may not provide the same desktop wizard in every version; if you cannot find the command, open the workbook in the desktop app.

Use a formula when you want the split to update

Text to Columns is useful for a one-time conversion. A formula is often better when the source value may change and you want the separated results to recalculate automatically. In Microsoft 365 or Excel 2024, TEXTSPLIT can divide text around a delimiter and return the results into adjacent cells.

With the source text North,West in A2 and empty cells to the right, enter this formula in B2:

=TEXTSPLIT(A2,",")

The result is “North” in B2 and “West” in C2. TEXTSPLIT returns a spilled array, so the cells where the results need to appear must be clear. If a value is later changed in A2, the displayed results update. The formula separates text; it does not create independent worksheet cells inside A2.

For a different separator, replace the comma inside the formula with the character used in the source. For example, a semicolon-delimited value needs a semicolon as the delimiter. If the source is inconsistent—some rows use commas while others use spaces—cleaning the data or choosing a more reliable delimiter may be necessary before splitting.

Split one worksheet window into panes

Excel does have a feature named Split, which is a common reason people think a cell-splitting command has disappeared. On Windows, choose View > Split. Excel divides the worksheet window into separate panes, allowing you to scroll different parts of the same sheet independently. It does not change the cells or divide a cell into smaller units.

To control where the dividing lines appear, select a cell near the place where you want the split and then use View > Split. The exact pane arrangement depends on the selected cell. Choose View > Split again to turn the split off. Excel for Mac also has a worksheet-window Split feature, although its placement or appearance can vary slightly by release.

Split is handy when comparing distant parts of a large worksheet—for example, checking a row of totals while reviewing entries much farther down. If your goal is to keep headings visible while scrolling, View > Freeze Panes is usually a better fit. Freeze Panes holds selected rows or columns in place; Split gives you independently scrollable sections. Neither option changes the worksheet’s underlying data.

Why merging cells is not the same thing

Excel’s merge commands can make a group of cells appear to be one larger cell, but they cannot reverse that effect by splitting the merged area into arbitrary smaller pieces. To undo a merge, select the merged cell and choose Home > Merge & Center > Unmerge Cells. The original grid boundaries return, although the contents do not necessarily return to the cells they came from.

Take care when merging cells that contain data. Excel keeps the contents of the upper-left cell and discards the contents in the other cells in the merged range. Unmerging later restores the cells, but it does not restore discarded values. If you need to preserve all entries, copy or combine them before merging.

Often, merging is not needed just to create a heading across several columns. A heading can be placed in one cell and centered or formatted without making the surrounding cells part of a merged range. Avoiding merges can make sorting, filtering, and selecting ranges easier, particularly in data tables.

How to choose the right approach

Start by identifying whether you want to change the data, the grid, or only what you see on screen. The right tool depends on that goal:

Separate values such as city and state: Use Data > Text to Columns for a one-time split, or TEXTSPLIT in Microsoft 365 or Excel 2024 when you want formula-driven results.
Make room for an extra value in the worksheet: Insert a row or column. This changes the shared grid rather than dividing just one cell.
Keep two areas visible while scrolling: Use View > Split. Choose Freeze Panes instead when you want headings or labels to stay fixed.
Undo a large heading made by merging: Use Home > Merge & Center > Unmerge Cells, after checking whether values were lost during the original merge.
Make a cell look divided without changing its structure: Use borders, alignment, or separate adjacent cells. A border can suggest a visual division, but it does not create another cell or store a second value.

For a worksheet intended for sorting and filtering, separate adjacent cells are usually more reliable than merged cells or decorative workarounds. For a printed form, appearance may matter more, so borders and carefully sized rows or columns may be sufficient. Keep the intended use in mind before changing the grid.

Common problems when splitting text

The most frequent issue with Text to Columns is overwriting data. If the split results need two or three columns but those cells already contain information, Excel may replace it. Insert empty columns first or choose a different destination in the wizard. Saving a copy before a large conversion is also sensible, especially when the source data is important.

Another common problem is choosing the wrong delimiter. A comma-separated list may include commas inside quoted descriptions, while a space-separated list may contain names or addresses with internal spaces. Review the wizard’s preview before finishing. If the preview breaks values in the wrong places, cancel and use a more suitable delimiter or a more controlled formula-based approach.

Formula results can also be blocked. If TEXTSPLIT returns a spill-related error, check whether cells in the expected output area contain values, spaces, or merged cells. Clear the obstruction or move the formula to an open area. Also confirm that the Excel version supports TEXTSPLIT; it is available in Microsoft 365 and Excel 2024, not every older perpetual edition.

Finally, remember that splitting text changes the shape of the data. After converting a single column into several, check whether each row still represents one record and whether headings match the new columns. A correct-looking split can still produce poor data if, for instance, a product description is divided differently from row to row.

Frequently Asked Questions

Did Excel remove the Split Cells button?
No. Excel does not have a command for splitting one individual worksheet cell into smaller cells. The Split command in Excel divides the worksheet window into panes, while Text to Columns separates text into multiple cells.

How do I split a cell in Excel into two columns?
Select the source cells, choose Data > Text to Columns, and select the delimiter that separates the two values. Alternatively, in Microsoft 365 or Excel 2024, use TEXTSPLIT with the delimiter in a formula.

Can I split a cell diagonally in Excel?
Excel cannot create two independently editable cells by dividing one cell diagonally. You can apply a diagonal border for appearance, but both labels or values still need to be arranged using the worksheet grid, text alignment, or neighboring cells.

What is the difference between Split and Freeze Panes?
Split creates multiple independently scrollable panes in the worksheet window. Freeze Panes keeps selected rows or columns visible while you scroll the rest of the sheet. Neither feature divides a cell or changes its contents.

Can I split a merged cell back into the original cells?
You can select it and choose Home > Merge & Center > Unmerge Cells to restore the grid boundaries. However, unmerging does not recover values discarded from cells when they were originally merged.

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.