How to Split Cells in Excel: Text, Names and Merged Cells (2026)

You've got a column of full names, or an address crammed into one cell, and you need it in pieces so you can sort, filter or mail-merge it. That's the moment most people go looking for a Split Cells button in Excel, and it's the moment they get confused, because there isn't one for ordinary cells.

What you want depends on what you mean by split. Excel has one answer for text sitting in a cell and a different answer for a cell you merged earlier. I'll take them in turn, following Microsoft's own help pages, so you pick the right route first time.

Why Excel has no Split Cells button for a normal cell

Microsoft's help for merging cells states it plainly: you can't split an individual cell. What you can do is make a cell look split by merging the cells above it. So if you wanted a header that spans two columns with two separate cells beneath, you build that by merging the top row, not by cutting the cell below in half.

That surprises people who are used to Word, where a table cell really can be divided. In Excel the grid is fixed. Every cell is one cell, and your options are to merge, unmerge, or move the text into more cells.

What you want	What Excel offers
Break one cell of text into several cells	Text to Columns on the Data tab
Undo a merge you made earlier	Unmerge Cells under Merge & Center
Make a header look split over columns	Merge the cells above it
Cut one cell in half like a Word table	Not possible in Excel

Splitting text in one Excel cell into separate columns

This is the route for names, addresses, codes and anything else separated by a comma, space or similar mark. Microsoft calls it the Convert Text to Columns Wizard. According to its help page, the steps are:

1. Select the cell or the column that holds the text.
2. Go to the Data tab and click Text to Columns.
3. In the wizard, choose Delimited and click Next.
4. Tick the delimiters that match your data. Microsoft's example uses Comma and Space. The Data preview window shows you how the text will break up.
5. Click Next.
6. Type the Destination cell, which is where you want the split text to start.
7. Click Finish.

Microsoft's merge help adds a practical note for this route: pick one column of data and make sure there are enough empty columns to its right. If the cells beside your data already hold something, you could overwrite it, so insert some blank columns first.

Microsoft's page for this wizard says it covers the current Microsoft-supplied Excel and several older versions, so menus can differ a little by version. If your ribbon looks different, look for Text to Columns on the Data tab or use the Help search box.

A worked example: first name and last name in one cell

Say column A holds names like Maria Lopez, one per cell. Select the column, run Text to Columns, choose Delimited, tick Space and set the Destination to the first empty cell in column B. After you click Finish, the first names sit in column B and the last names in column C.

Where a name has a middle name, the space delimiter will cut it into three parts, and the wizard doesn't guess which part is which. Check the Data preview before you finish, and tidy the odd rows by hand afterwards.

Unmerging merged cells in Excel

If a cell looks wide because you merged it earlier, the fix is to reverse the merge. Microsoft's steps for Windows are short:

1. Select the merged cell.
2. On the Home tab, click the down arrow next to Merge & Center.
3. Choose Unmerge Cells.

If you've only just merged by mistake, press Ctrl + Z to undo it straight away. Microsoft doesn't list a separate shortcut for unmerging.

One thing to know before you unmerge: Microsoft's help says merging keeps only the upper-left cell's content and deletes the contents of the other cells you merge. Unmerging doesn't bring that text back. If the text matters, undo the merge immediately or retype it.

Finding merged cells before you split anything

A sheet with merged cells scattered through it can make sorting and filtering misbehave. Microsoft's help says you can use the Find command to locate merged cells, which is handy when you inherit a spreadsheet and don't know where the merges are hiding.

Microsoft also notes that Merge & Center may be greyed out if you're in the middle of editing a cell or if the cells are formatted as a table. Press Enter or Esc to finish editing first, and remember that table cells can't be merged at all.

Splitting cells in Excel for a small business spreadsheet

The usual jobs I see are customer lists, order exports and contact sheets. A shop owner might have a full name and postcode together in one column from an export. A freelancer might have a client name and project code in one cell. Splitting them into columns means you can sort by surname, filter by code or feed the sheet into a mail-merge.

• Keep a copy of the original column before you split, so you can go back if the delimiter was wrong.
• Split into columns to the right of your data, not over the top of it.
• Check a handful of rows after the split, especially ones with extra spaces or commas inside the text.
• Avoid merging cells in anything you plan to sort, filter or turn into a pivot table.

If your team works in Google Sheets as well, I've written about the same job there in my guide to merging cells in Google Sheets. And if you want an AI helper alongside your spreadsheet, there's my walk-through of installing Claude for Excel and what to ask it.

If you can't split cells in Excel the way you expect

Work through these in order:

1. Check whether the cell is merged. If so, use Unmerge Cells. If not, you need Text to Columns, not a merge command.
2. If Text to Columns is greyed out, make sure you've selected a single column of data and that you're not still editing a cell.
3. If the split text lands in the wrong place, undo with Ctrl + Z and run the wizard again with a different Destination cell.
4. If your data sits in a table, Merge & Center may be unavailable, so work on a range instead.
5. If your ribbon doesn't match these names, your version of Excel may differ, so search the Help box for Text to Columns.

Frequently asked questions

Can you split a cell in Excel?

Not an individual cell. Microsoft's help says you can't split one, though you can make a cell look split by merging the cells above it. To break the text in a cell across several cells, use Text to Columns on the Data tab.

How do I split text into columns in Excel?

Select the cell or column, go to Data, click Text to Columns, choose Delimited, tick the delimiter that matches your data, check the Data preview, set a Destination and click Finish.

How do I unmerge cells in Excel?

Select the merged cell, click the down arrow next to Merge & Center on the Home tab and choose Unmerge Cells. If you've just merged, Ctrl + Z undoes it.

Why is Merge & Center greyed out?

Microsoft's help says it may be disabled if you're editing a cell or the cells are formatted as a table. Finish editing first, or work on a normal range.

Will splitting text overwrite my data?

It can, if the columns to the right already hold something. Microsoft advises leaving enough empty columns to the right of the data you split, or choosing a Destination cell in a clear area.