Split a Cell in Excel: Separate Text or Unmerge Cells

Excel cannot divide one worksheet cell into two independent cells; to separate its contents, use Data > Text to Columns or a formula such as TEXTSPLIT. To divide the worksheet view on screen, choose View > Split—that is a different feature.

What “split a cell” means in Excel

The phrase can mean several things, and the right method depends on what you want to change. If a cell contains a full name, address, or code that needs to become separate values, split the text across neighboring cells. If several cells were combined into one large merged cell, unmerge them. If you want to see two areas of a worksheet at once, split the window panes. Excel does not offer a command that cuts a single cell’s physical area into smaller, independently editable cells while leaving the surrounding grid unchanged.

A worksheet cell is already the intersection of one row and one column. Making two smaller cells inside that space would require changing the grid, which would affect other cells in the same rows or columns. Instead, Excel’s text-splitting tools put the resulting parts into adjacent cells. For example, splitting the value Ava Chen in A2 can put Ava in B2 and Chen in C2, while A2 remains the source unless you choose to overwrite it.

Split text with Text to Columns

For a one-time separation, Text to Columns is often the clearest option in Excel for Microsoft 365 on Windows. It works on a selected column and places the results in columns to its right, or in another destination you specify.

Make a copy of the source column or workbook if the original values matter. Select the cells containing the text you want to divide.
Choose Data > Text to Columns.
In the wizard, choose Delimited if a character such as a comma, space, or tab separates the parts. Choose Fixed width if the values line up at consistent character positions. Select Next.
For Delimited, check the relevant separator and review the data preview. For Fixed width, add or move the break lines in the preview. Select Next.
Choose a destination if you do not want the results to begin in the source column. Check the column data format, then select Finish.

Suppose A2 contains Chen, Ava. Selecting the comma as the delimiter separates the value into Chen and Ava in neighboring columns. If the comma is followed by a space, choose comma as the delimiter and decide whether to also select Space. Selecting both can be useful when data is consistently formatted; otherwise, a leading space may remain in the second result. Always inspect the preview before finishing, because the separator choice determines how every selected row is divided.

Text to Columns is available in Excel for Mac too, though the ribbon layout and dialog appearance can differ slightly by release. Look on the Data tab for Text to Columns. In Excel for the web, editing features can vary; if the command is not available in your web version, open the workbook in the desktop app to use the wizard.

Choose a delimiter or fixed width

A delimiter is a character or marker that identifies where one part ends and the next begins. Common examples include commas in CSV-style data, spaces between names, tabs between copied fields, and hyphens in product codes. Delimited splitting is most reliable when the separator has the same meaning throughout the selected data.

Use a delimiter for lists such as city,state, postal code or first name and last name separated by a comma.
Use fixed width for consistently positioned data, such as a report where the first 10 characters are an account code and the rest are a description.
Use a different delimiter or cleanup step when the separator also appears inside a value. A comma in a person’s name or a product description, for instance, may split the row in an unintended place.

The wizard’s options can include treating consecutive delimiters as one and identifying a text qualifier. These matter when the source has repeated separators or text enclosed in quotation marks. For a file such as a properly formatted CSV, quotation marks can indicate that a comma belongs inside a field rather than marking a boundary. If you are unsure how the data is structured, test a few representative rows first instead of converting the entire column.

Split text with a formula

A formula is a better fit when the source values may change and you want the separated results to update automatically. In Microsoft 365 and Excel 2024, TEXTSPLIT can divide a value at a chosen delimiter and spill the pieces into adjacent cells. With the text in A2, enter this in B2:

With the full name in A2, =TEXTSPLIT(A2," ") returns Ava in B2 and Chen in C2 when A2 contains Ava Chen.

The formula results occupy a spill range. Keep the cells where the results will appear empty; otherwise Excel may show a #SPILL! error. If the source contains a middle name, the formula can return three parts, so leave enough clear columns for the longest expected result. TEXTSPLIT is available in Microsoft 365 and Excel 2024, not Excel 2021 or older perpetual releases.

For a value with exactly one comma, a formula can also extract the text before and after it. With Chen, Ava in A2, enter =TEXTBEFORE(A2,",") in B2 to return Chen, and enter =TEXTAFTER(A2,",") in C2 to return Ava. These functions are available in Microsoft 365 and Excel 2024. The second result includes any space after the comma, so a value such as Chen, Ava may show a leading space. You can clean that result with TRIM, for example, =TRIM(TEXTAFTER(A2,",")).

Formulas are useful for repeatable processing, but they do not replace the original value automatically. If you need fixed results rather than formulas, copy the output and use Home > Paste > Paste Values. Check the output before removing the source data.

Protect the original data and formatting

Before splitting a column, consider what is in the neighboring cells. Text to Columns can write results over existing data, so set a destination in an empty area or move the neighboring content first. A backup copy is especially important when the operation affects many rows or when you are cleaning imported data.

Also check how Excel interprets each resulting column. A sequence such as 00127 may be treated as a number and lose its leading zeros. Dates can be interpreted according to regional settings, and codes that resemble dates can be converted unexpectedly. In the wizard, select a column in the preview and choose Text when the exact characters must be preserved. After splitting, compare a few rows against the source, including unusual entries and blank values.

If the data needs to be refreshed regularly, consider keeping the source column intact and placing formulas beside it. If it is a one-time cleanup and you have verified the output, Text to Columns may be quicker. In either case, preserve a copy until you are confident that the split has not dropped characters, changed dates, or shifted values into the wrong columns.

Unmerge cells instead of splitting text

If you see a wide cell spanning several columns, it may be a merged cell. To undo the merge, select it and choose Home > Merge & Center > Unmerge Cells. The command separates the grid cells again, but it does not divide the text that was in the merged area. Excel generally keeps the contents in the upper-left cell of the former merged range; the other cells are empty. If the aim is to distribute a label across cells, copy or split the retained text separately.

Merged cells can make sorting, filtering, and copying ranges more awkward, particularly when a merge covers only some rows. For worksheet layouts, Center Across Selection is sometimes an alternative: open Format Cells, choose the Alignment tab, then set Horizontal to Center Across Selection. This centers a label across selected columns without merging those cells. It is a formatting choice, not a way to split text.

Split the worksheet view, not a cell

View > Split divides the worksheet window into independently scrollable panes. It does not change cell contents, row heights, or column widths. Use it when you want to compare distant parts of a large sheet—for example, keep headings near the top visible while scrolling through records below, or view two sections side by side.

Select a cell near where you want the division, then choose View > Split. Excel places pane boundaries based on the selection; drag a boundary to adjust it. Choose View > Split again to remove the split. If you only need to keep headings visible while scrolling, View > Freeze Panes may be more suitable. Freeze Panes locks selected rows or columns in place; Split creates separate viewing areas that can scroll independently.

Common problems and how to fix them

The results overwrite other values: undo immediately if possible, or restore the backup. Before running Text to Columns again, choose an empty destination.
Every word goes into a separate column: the selected delimiter is probably too general. If you only want to split at a comma, clear Space and other unused delimiter boxes.
A #SPILL! error appears: clear the cells that block the formula’s output range, or move the formula to an area with enough empty columns.
Leading zeros disappear: set the output column format to Text before conversion, or restore the original codes from a backup. Changing a number’s display format afterward may not restore lost characters.
Some rows split differently: the source may use inconsistent separators, extra spaces, or separators inside quoted text. Review those rows and standardize the source or handle exceptions separately.

Excel’s Undo command can reverse many recent worksheet actions, but it is not a substitute for a backup—especially after additional edits or when working with imported files. For a formula-based split, fixing the source value or the formula is usually safer than editing each spilled result by hand.

Frequently Asked Questions

Can I split one Excel cell into two cells?
Not as a physical subdivision inside the same grid position. You can split its text into adjacent cells with Text to Columns or a formula, or change the worksheet’s row and column structure to create more cells.

How do I split a cell diagonally in Excel?
Excel does not create two independently editable triangular cells. You can add a diagonal border through Format Cells > Border and position text with line breaks or text boxes, but that is only a visual layout.

How do I split first and last names?
If names use a consistent separator, select the name column and use Data > Text to Columns with Space as the delimiter. For names with middle names, suffixes, or compound surnames, a simple space split may produce more columns than intended; inspect the results and choose a method suited to the naming pattern.

Does Text to Columns delete the original cell?
It can replace the source column with the first part of the split, depending on the destination you choose. To preserve the original, copy the source to another column first or set a separate empty destination in the wizard.

What is the difference between Split and Freeze Panes?
View > Split creates separate panes that can scroll independently. View > Freeze Panes keeps selected rows or columns visible while the rest of the sheet scrolls. Neither command changes the worksheet’s cell contents.

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.