How to Split One Cell into Two in Excel
To split one cell into two in Excel, select the cell, go to Data → Text to Columns, choose a delimiter (like a space or comma), and finish — Excel pushes the second piece into the next column. If you’d rather not touch the original data, use a formula or Flash Fill to pull each part into its own cell instead. Below you’ll find every reliable way to divide a cell, which one to pick, and how to make it work on both Windows and Mac.
One thing to clear up first: Excel cells are not like Word table cells. You cannot literally cut a single cell in half — Excel always splits the contents of a cell across two or more separate cells (usually neighboring columns). Once you understand that, the rest is easy.
The Fastest Way: Text to Columns
Text to Columns is the built-in tool designed for exactly this job. It takes the text in one cell and spreads it across multiple columns based on a separator character.
- Select the cell (or the whole column) you want to split.
- Go to the Data tab on the ribbon.
- Click Text to Columns.
- Choose Delimited and click Next.
- Tick the delimiter that separates your values — Space, Comma, Tab, Semicolon, or a custom character under Other.
- Click Next, set the destination cell if you want to keep the original, then click Finish.
Excel drops the first chunk into the original cell and the second chunk into the cell to its right. Make sure the columns to the right are empty first, or Excel will overwrite them — it warns you before it does.
Tip: If your data lines up at fixed positions instead of a separator (for example, a product code where the first 3 characters are always the category), choose Fixed width in step 4 and click the ruler to set break points.
Text to Columns is a one-time conversion. If your source data changes later, you’ll have to run it again. For a live result that updates automatically, use a formula instead — see below. This is the same engine behind splitting first and last names and breaking apart a full address.
Split a Cell with Flash Fill (No Formulas Needed)
Flash Fill watches what you type and finishes the pattern for you. It’s perfect when the split rule is hard to describe with a delimiter.
- In the column next to your data, type the first part you want (e.g. just the first name).
- Press Enter and start typing the second row — Excel shows a gray preview of the rest.
- Press Enter to accept, or use the shortcut: Ctrl + E on Windows, Control + E on Mac.
If the preview doesn’t appear, type two or three examples first so Excel can detect the pattern. Flash Fill requires Excel 2013 or later (it’s also in Microsoft 365 and Excel for Mac 2016+). Learn more about using Flash Fill and what to do if Flash Fill isn’t working.
Split a Cell Using Formulas (Live and Reusable)
Formulas keep the original cell intact and recalculate whenever your data changes. The classic combination is LEFT, RIGHT, MID, and FIND.
Say cell A2 contains John Smith and you want the first and last name in separate cells:
| Goal | Formula | Result |
|---|---|---|
| First word (before the space) | =LEFT(A2, FIND(" ", A2) - 1) | John |
| Everything after the space | =MID(A2, FIND(" ", A2) + 1, LEN(A2)) | Smith |
| Last word using RIGHT | =RIGHT(A2, LEN(A2) - FIND(" ", A2)) | Smith |
How it works: FIND returns the position of the space, LEFT grabs the characters before it, and MID or RIGHT grabs the rest. Subtracting or adding 1 trims the space itself.
The Modern Way: TEXTSPLIT
If you have Microsoft 365 or Excel 2021/2024, TEXTSPLIT does the whole job in one formula and spills the results across cells automatically:
=TEXTSPLIT(A2, " ")This splits A2 on every space and fills the cells to the right. You can split on multiple delimiters too — =TEXTSPLIT(A2, {" ", ","}) handles both spaces and commas. TEXTSPLIT is the cleanest method available, but it only exists in current versions. On older Excel, fall back to the LEFT/MID/RIGHT approach above or to Text to Columns. For a deeper walkthrough see our guide to splitting text in Excel.
Splitting Cells on Mac vs. Windows
The methods are nearly identical across platforms, with small differences in menu labels and shortcuts.
| Action | Windows | Mac |
|---|---|---|
| Text to Columns | Data tab → Text to Columns | Data tab → Text to Columns |
| Flash Fill shortcut | Ctrl + E | Control + E |
| Undo a split | Ctrl + Z | Cmd + Z |
| TEXTSPLIT / formulas | Same syntax | Same syntax |
Flash Fill on Mac requires Excel 2016 or later and sometimes has to be triggered from Data → Flash Fill rather than the keyboard. Everything else behaves the same.
What About Splitting a Cell “Diagonally”?
People sometimes search for splitting a cell to create a header that labels both a row and a column — a diagonal line through the corner cell. Excel can’t split the cell itself, but you can fake it: right-click the cell → Format Cells → Border tab → click the diagonal border button, then type both labels and use line breaks (Alt + Enter on Windows, Control + Option + Enter on Mac) to position them. It’s purely visual and doesn’t separate any data.
Should You Split, or Merge Instead?
Splitting and merging are opposites, and the right choice depends on your goal:
- Split when one cell holds two facts that you need to filter, sort, or calculate separately (a name, an address, a date and time).
- Merge when you want to combine values for display — see combining two columns or combining cells.
If you previously merged cells and now need them back, use unmerge cells. And if you’re working with large, repeatable datasets, Power Query can split columns on import and refresh the result every time the data updates — far better than re-running Text to Columns by hand.
Troubleshooting Common Problems
Text to Columns overwrote my data. It writes into the columns to the right. Insert blank columns first, or set a different Destination in the final wizard step.
My split won’t happen — the wizard does nothing. You probably picked the wrong delimiter. Look closely at your data: values may be separated by tabs or non-breaking spaces rather than regular spaces. Use Other and paste the exact character.
Numbers turned into dates or lost leading zeros. In the final wizard step, set the column’s Column data format to Text before clicking Finish.
Extra spaces are clinging to my results. Wrap your formula or cleaned column in TRIM() to strip leading and trailing spaces.
TEXTSPLIT shows #NAME?. Your Excel version doesn’t include the function — use Text to Columns or LEFT/MID/RIGHT instead.
Frequently Asked Questions
How do I split one cell into two in Excel?
Select the cell, go to Data → Text to Columns, choose Delimited, pick the character that separates your values (such as a space or comma), and click Finish. Excel places the first part in the original cell and the second part in the next column. To keep the original untouched, use a formula like =TEXTSPLIT(A2," ") or the LEFT/MID/RIGHT combination instead.
How do I divide a cell in Excel?
There’s no command that physically halves a single cell — Excel divides a cell’s contents into separate cells. Use Text to Columns for a one-time split, Flash Fill (Ctrl + E / Control + E) to follow a pattern, or formulas for a live result. See our guide to dividing Excel cells for examples.
Can I split a cell without using Text to Columns?
Yes. Flash Fill and formulas both split a cell while leaving the original intact. Flash Fill needs no formula at all — just type a couple of examples and press Ctrl + E. Formulas like =LEFT(), =MID(), and =TEXTSPLIT() recalculate automatically when your data changes.
How do I split a cell into two rows instead of two columns?
Text to Columns only splits horizontally into columns. To stack values vertically, split into columns first, then copy the result and use Paste Special → Transpose. With TEXTSPLIT you can spill the parts downward by passing your separator as the row delimiter (the second argument): =TEXTSPLIT(A2,," ") splits A2 on spaces into a vertical column.
Why does my cell split overwrite the next column?
Text to Columns writes its second piece into the cell directly to the right. If that cell already contains data, Excel replaces it. Insert an empty column before splitting, or change the Destination box in the last wizard step to point at a blank area.
Can I split cells diagonally in Excel?
Not for real — Excel only separates contents into different cells. You can add a diagonal border through Format Cells → Border to create a labeled header, but it doesn’t divide any data.
Final Thoughts
Splitting one cell into two comes down to three tools: Text to Columns for a quick one-off, Flash Fill for pattern-based splits with no formulas, and TEXTSPLIT (or LEFT/MID/RIGHT) for a live, self-updating result. Pick Text to Columns when you just want it done, and a formula when the data will keep changing. From there, the same skills let you split names, separate text from numbers, and clean up almost any messy column in your spreadsheet.
