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

Excel

Samuel Daniel

Update 05 April 2024

You should read it

May be interested

3 ways to convert time to decimal numbers in Excel and how to convert it back
in this article, we will show you 3 ways to convert time to decimal numbers in excel and how to convert it back. please follow the following article to know how to do it in detail
How to draw straight lines and arrows in Excel - Draw shapes in Excel
there are many different ways to draw straight lines and arrows in excel. lines and arrows in excel are often used to draw mind maps in excel or graph functions in excel.
Simple tips to help optimize your job search resume
in an increasingly competitive labor market, to help employers distinguish between you and a crowd of applicants, you need to spend time tailoring your resume to suit each different job.
4 Free spreadsheet software that can replace Micorsoft Excel
microsoft excel is still the number one name in the field of spreadsheet processing. however, the biggest problem here is that excel incurs expensive licensing fees. fortunately, there are a number of free spreadsheet software that can replace excel. please read the following article to choose the most suitable solution for yourself.
Tips on how to copy charts from Excel to Word while maintaining the format
excel and word are two software in microsoft's microsoft office suite. most users regularly use these two software. do you know how to copy charts from excel to word with the format intact? read this article for instructions on how to do it!
What is the error 'Something went wrong'? Quick fix when using Word
what is the error 'something went wrong'? this is a fairly common error many people encounter when opening microsoft word. please follow the following article to know how to fix this error.