How to Split One Cell into Two in Excel

In this tutorial, you will learn how to split one cell into two in Excel.

Tables in your Excel can have their appearance altered by grouping, dividing, or erasing table cells.

Once ready, we’ll get started by utilizing real-world examples to show you how to split one cell into two in Excel.

Split One Cell Into Two

Before we begin we will need a group of data to split one cell into two in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with. You will also find out that you can only split cells that were merged previously.

Step 2

To split one cell into two, you can simply select the merged cell and select ‘Unmerge Cells’.

Step 3

Once you are done, your cell value will look like this.

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

In this tutorial, I covered how to split one cell into two in Excel.