How to Split a Cell in Excel Microsoft Office 365?


There are two unique capacities that empower clients to part a cell. The choice of “Consolidation and Center” under the Home tab, permits clients to combine two cells and afterward unmerge them on a cell that has converged with another cell. Other choice “Message to Columns” under the Data tab parts the cell into sections. It changes over the message of a cell into discrete sections for each word inside the message. However the state of parting a cell can be changed or modified by space between the words or by character between the words, for example, a comma relying on the information.

Steps for splitting two merged cells.

Microsoft Excel

These are the two merged cells, users can also merge more than two cells by selecting the cells and clicking the “Merge & Center” option from the home tab.

Micro Excel

  • Now, select the merged cell that you want to split or unmerged and click the “Merge & Center” button directly or click the arrow for the list of options and click “Unmerge Cells” from the list.

Steps for Splitting Cell text into Columns

Excel data

Click the Data tab from the top.


Select your desired cell to transform into numerous segments by the “Message to Columns” button.

Microsoft Excel

Click the “Text to column” button from the ribbon above the excel sheet, where all the functions are given.

Columns Excel

A window to change Text over completely to Columns will show up, pick the record type that depicts your information assuming it has characters like commas or tabs isolating each field or its proper width of room between each word. Then, at that point, click “Next” to change the break line.

Delete Colums Excel

Another window will show up in which you can change the break line between the words. To make the break line click on the ideal position. To erase the break line double tap on the connection. What’s more, to move a break line snap and drag it. Click “Next” for the following setting levels for choosing the information design for every segment.


In this window, you can select the format for each column by selecting from the column data format. Once you are done click the “Finish” button from the bottom of the window.

Microsoft Excel

Presently you can see that the message of a cell has isolated into numerous segments.
Ideally, the article has helped you to determine your question. You can keep in touch with us in the event that you really want backing or help with a specific component or program of office 365 or other Microsoft programs.

Microsoft Office 365

Leave a Reply

Your email address will not be published.

Related Posts