Instructions for dividing 1 cell into multiple cells in Excel

The operation of dividing a cell into multiple cells in Excel is a basic operation when processing data tables. There are many purposes for dividing a cell in Excel such as data analysis and statistics, data standardization, etc. Previously, Network Administrator showed you some ways to merge multiple cells in Excel. And in this article you will learn how to divide 1 cell into multiple cells in Excel, with a very simple implementation.

Divide 1 cell into 2 cells in Excel using a diagonal

Diagonal cell division type to enter content in the same cell but of 2 different data types. Please follow the article below to learn how to divide cells in Excel diagonally.

How to divide cells in Excel after merging cells

After merging cells in Excel, if you want to split cells, it is also very simple. In the merged cell that we want to split, we highlight the cell and then click Merge & Center again to deselect merging cells .

Instructions for dividing 1 cell into multiple cells in Excel Picture 1

How to divide cells in Excel using Text to Columns

Text to Columns is a tool available in Excel used to split cells or columns in Excel into multiple columns.

Step 1:

Select a cell in the data table that you want to split, then click Text to column in the Data tab as shown below.

Instructions for dividing 1 cell into multiple cells in Excel Picture 2

Step 2:

Display the new interface, click Delimited and then click Next to continue.

Instructions for dividing 1 cell into multiple cells in Excel Picture 3

Switch to the next interface, select Space to separate by spaces and then click Next below to proceed. We will see that each content in the cell has been separated into different cells.

Instructions for dividing 1 cell into multiple cells in Excel Picture 4

Step 3:

Finally, select the location to display the new split content at Destination and then click Finish to split 1 cell into multiple cells in Excel.

Instructions for dividing 1 cell into multiple cells in Excel Picture 5

Step 4:

As a result, you will see the data in 1 cell separated into many cells as shown.

Instructions for dividing 1 cell into multiple cells in Excel Picture 6

In case you want to convert from row to column or vice versa , copy the content you want to convert and then right-click in the new content area, select Paste Special , then select Transpose to convert.

Instructions for dividing 1 cell into multiple cells in Excel Picture 7

As a result, we get rows or columns as shown below.

Instructions for dividing 1 cell into multiple cells in Excel Picture 8

Samuel Daniel

Update 05 April 2024