How to Split a Cell in Microsoft Excel

To split the contents of a cell into separate columns in Microsoft Excel, select the cells, then choose Data > Text to Columns and follow the wizard. If you mean splitting the cell itself into smaller grid cells, Excel cannot divide one cell that way; use neighboring cells to create the layout you need. Make a copy of your data first, because splitting text can overwrite cells to the right.

What You’ll Need

Excel for Microsoft 365 on Windows for the menu steps below. The Text to Columns feature is also available in Excel for Mac, though ribbon layout can vary slightly.
A cell or column containing text with a consistent separator, such as a comma, space, tab, slash, or hyphen—or values that follow a consistent character-width pattern.
Empty cells to the right of the source column for the split results. If you are splitting several rows, leave enough empty columns for the row with the most parts.
A backup or duplicate of the original data if you may need to preserve it unchanged.

Step-by-Step

Check what kind of split you need. Excel can separate the text inside a cell into multiple cells, such as changing Jordan Lee into first and last name columns. It cannot cut one ordinary worksheet cell into two independently addressable cells while leaving the surrounding grid intact. If you need two entry areas side by side, use two adjacent columns; if you need a visual subdivision, see the tips below.
Prepare a safe output area. If the values are important, copy the original column and paste it into a new sheet or an unused area. For example, if the text is in A2:A50, make sure columns B and onward are empty for every row that will be split. Text to Columns writes results into the selected destination and can replace existing data without a separate warning for every affected cell.
Select the source cells. Click the first cell in the column, or drag across the range you want to split. You can select a whole column if every used entry should be processed, but selecting only the filled range helps avoid unintended changes to unrelated cells. The selected cells should generally be in one column for a straightforward split.
Open the conversion wizard. On the Windows ribbon, choose Data > Text to Columns. In Excel for Mac, select the Data tab and choose Text to Columns; the dialog may look different, but the basic choices are similar. If you are using Excel for the web and cannot find this command, open the workbook in the desktop app or use a formula-based approach described below.
Choose how Excel should find the split points. Choose Delimited when a character marks each boundary. This is the usual choice for comma-separated lists, names separated by spaces, or codes separated by hyphens. Choose Fixed width when each part occupies a predictable position, such as a legacy code with the first four characters always representing a department. Click Next.
Set the delimiter or column breaks. For Delimited, check the character that separates the parts: Tab, Semicolon, Comma, or Space. To use another character, check Other and enter it in the box. Watch the data preview: the vertical lines show where Excel intends to divide the text. For Fixed width, click in the preview to add a break line, drag a line to move it, or double-click one to remove it. Choose Next when the preview matches the result you want.
Review text and number handling. In the final step, select a column in the preview and choose its data format if needed. General lets Excel interpret values as numbers or dates; Text keeps the characters as text, which is useful for postal codes, product IDs, and account numbers that may begin with zero. If a date-like value must retain its exact original appearance, choose Text for that output column. Do not assume General will preserve leading zeros.
Choose a destination before finishing. The destination box normally points to the first selected cell. Change it to an empty starting cell if you want to keep the source unchanged—for example, set the destination to B2 when the original values start in A2. Confirm that enough blank columns are available for all split parts. Click Finish, then inspect several results, including rows with the longest or least typical entries.
Use a formula when you need a live split. Text to Columns creates a one-time result, so it will not automatically update when the source text changes. With a comma-separated value in A2, enter this formula in B2 in Microsoft 365 or Excel 2024: =TEXTSPLIT(A2,","). For example, if A2 contains red,blue,green, the formula spills into B2:D2 as red, blue, and green. Leave those spill cells empty. Replace the comma inside the formula with the delimiter used in your data. TEXTSPLIT is available in Microsoft 365 and Excel 2024, but not in some older perpetual versions.
Check and clean the results. Look for missing pieces, extra spaces, or values that were interpreted as numbers or dates. If you used a space as the delimiter, a full name such as Jordan Lee becomes two parts, but a name with a middle name becomes three. If a field itself contains the delimiter, a simple split may divide it incorrectly; review those rows and choose a more suitable method or clean the source first.

Common Mistakes

Splitting over existing data: Text to Columns places each result in consecutive cells. If those cells contain notes, formulas, or other records, the split can replace them. Choose a blank destination or duplicate the source sheet before you start.

Choosing the wrong delimiter: A comma is not always the separator you need, and spaces can be especially risky. In Lee, Jordan, a comma separates the name neatly; in Jordan Lee, a space works only if every entry has exactly two parts. Check the preview before finishing rather than relying on the selected option alone.

Dropping leading zeros or changing dates: Excel may convert text such as 00427 to the number 427, or interpret a date according to regional settings. Set affected output columns to Text in the wizard when the exact characters matter, and verify the result.

Expecting the original cell to remain split-linked: Text to Columns produces separate values, not a permanent relationship between the pieces and the original. If source entries will keep changing, use a supported formula such as TEXTSPLIT instead, or rerun Text to Columns after updating the source.

Confusing a split cell with unmerging: Merged cells combine multiple cells into one display area; unmerging restores the original grid cells, but does not divide a single value into parts. Use Text to Columns for separating text.

Tips

Use the preview as your test. A clean preview should show each intended part in its own column without splitting a field that should stay together. If one row looks wrong, investigate the source pattern before applying the split to the entire range.
Handle repeated separators deliberately. For data such as North,,West, the empty section between commas may matter. In the Delimited step, check Treat consecutive delimiters as one only when repeated separators should count as a single boundary. Otherwise, leave it unchecked so Excel can preserve the empty position.
Preserve the source until you verify the output. A useful workflow is to send the split results to an empty area, compare a few rows, and only then replace or remove the original column if that is your goal.
For a visual split, build with the grid. Put the two pieces in neighboring cells, adjust column widths, and apply borders or alignment to make them look like a divided area. This keeps each value usable in formulas and sorting. Avoid merging cells if you expect to sort or filter the range later.
On a Mac, use the same delimiter logic. The ribbon placement and dialog appearance can differ from Windows, but the choices are still based on delimiters or fixed widths. In Excel for the web, features and menus can vary; opening the workbook in desktop Excel is the reliable option when the Text to Columns command is unavailable.

Troubleshooting

Nothing appears in the expected columns. Check the destination shown in the wizard. It may still point to the source cell, or the selected range may not include the data you intended. Cancel if necessary, reselect the source, and choose a blank destination before finishing.

The split stops too early or creates too many columns. The delimiter might occur inside a field, or the entries may not follow one consistent structure. Review several source rows and decide whether a different delimiter, fixed-width breaks, or prior cleanup is appropriate. If commas are used both as separators and inside quoted text, make sure the wizard preview handles the text qualifier as expected; do not proceed if it visibly breaks a field incorrectly.

Text to Columns is unavailable or disabled. Confirm that you are in the desktop version and have selected a suitable range, then look under Data. If you are in a browser, the command may not be present in your current Excel experience; choose Open in Desktop App or use a formula supported by your version. A protected sheet or workbook can also restrict editing, so check whether you have permission to modify it.

TEXTSPLIT returns an error or will not spill. Check that your Excel edition supports TEXTSPLIT and that the formula uses straight quotation marks around the delimiter. If Excel reports a spill error, clear the cells where the results need to appear; merged cells in the spill area can also prevent the results from filling. If the formula displays as text, change the cell format to General and re-enter it, and make sure the cell does not begin with an apostrophe.

The output has unwanted spaces. A delimiter does not always remove spaces that sit beside it. For example, splitting red, blue can leave a leading space in the second result. You can clean the source values before splitting, or remove extra spaces from the results with Excel’s trimming tools. Inspect the underlying value as well as the way it appears in the cell.

Leading zeros or exact formatting disappeared. If you have not made other changes since the split, use Ctrl+Z on Windows or Command+Z on Mac to undo it. Then repeat the conversion and set the relevant preview column to Text. If you can no longer undo, restore the original copy or reimport the source data; formatting the converted number as Text afterward will not bring back zeros that were already removed.

Frequently Asked Questions

Can I split one Excel cell into two actual cells?

Not by cutting the cell itself in half. Excel’s worksheet grid uses consistent row and column boundaries. To divide text into separate values, use Text to Columns or a formula; to create a divided-looking area, use neighboring cells and format them.

How do I split a cell by a comma?

Select the cells, choose Data > Text to Columns, select Delimited, check Comma, review the preview, choose an empty destination if needed, and finish. For a formula-based result in Microsoft 365 or Excel 2024, TEXTSPLIT can separate a comma-delimited value dynamically.

Can I split text into rows instead of columns?

Text to Columns is designed to place split results across columns. In Microsoft 365 or Excel 2024, TEXTSPLIT can use a row delimiter to return items vertically, but the formula must specify that delimiter as its row delimiter. Older Excel versions may require a different formula approach or manual rearrangement.

Will the split update when I change the original cell?

No. Text to Columns makes a static conversion. A formula-based split such as TEXTSPLIT recalculates when its source changes, provided your Excel version supports the function and the cells needed for its output are clear.

Can I split a cell on a line break?

Yes, if the cell contains line breaks as separators, though identifying that delimiter in the Text to Columns wizard can be less straightforward than selecting a comma or tab. In a supported Excel version, a formula can use CHAR(10) as the row or column delimiter, depending on whether you want the results vertically or horizontally. Check the preview or result carefully before replacing the original data.

Does splitting a cell remove the original value?

It can, if the destination overlaps the source. Choose an empty destination to preserve the original. A formula also leaves the source in place, as long as you enter the formula in a different cell.

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.