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

3.5 ★ | 2 Vote

May be interested

  • How to use notes in Microsoft ExcelHow to use notes in Microsoft Excel
    comments in microsoft excel are simple text messages associated with individual cells. they are often used to add context to the cell's contents, explaining a few small details about the cell.
  • How to Create a List in Cells in ExcelHow to Create a List in Cells in Excel
    if you want to know how to create a list of multiple lines in a cell on microsoft excel, read this article! whether it's creating a bulleted list with line breaks, a numbered list, or a drop-down list, it's easy once you know where the options are. today's tipsmake will show you three useful ways to insert any kind of list into cells in excel.
  • How to automatically create valuable cell borders in ExcelHow to automatically create valuable cell borders in Excel
    there are many ways of highlighting valuable cells in excel, such as creating borders for cells automatically when entering values.
  • How to combine 2 or more cells in Excel without losing dataHow to combine 2 or more cells in Excel without losing data
    how to combine 2 or more cells in excel without losing data. when merging cells containing data into 1 cell, excel retains the data in the first cell only, data in the remaining cells are deleted. so to retain all data in the cells you need to merge, you cannot use the feature
  • How to use Focus Cell to highlight Excel dataHow to use Focus Cell to highlight Excel data
    excel focus cell feature is one of the useful features, highlighting the row and column of the active cell, helping you keep track of your location in the spreadsheet for easier reading across rows and columns.
  • How to name an Excel cell or data area - Define Name feature on ExcelHow to name an Excel cell or data area - Define Name feature on Excel
    in excel, users can name each individual cell or certain cells to easily remember the address of the corresponding cell when referring to the data area.
  • The COUNTIFS function, how to use the cell count function according to multiple events in ExcelThe COUNTIFS function, how to use the cell count function according to multiple events in Excel
    the countifs function in excel to count cells satisfies many given conditions.
  • How to cross cells in ExcelHow to cross cells in Excel
    you're making a table in excel and have a blank data cell and you want to cross that box but don't know how to do it. let tipsmake.com help you through the article how to cross cells in excel offline!
  • How to merge and split cells in WordHow to merge and split cells in Word
    how to merge and split cells in word. working with tables in word, sometimes you need to split a cell into multiple cells, or merge multiple cells into one cell to fit the requirements. if you do not know how to combine and split cells in word, then please refer to the article d
  • How to delete cells in ExcelHow to delete cells in Excel
    do you need to delete a content, format, or just want to delete the comment of a cell in excel? today dexterity software will guide you how to delete cells in excel offline.