Do you have numerous worths in a solitary cell that you wish to separate right into several cells? If so, Microsoft Excel has 2 user friendly options to help you divide your cells. We’ll show you exactly how to use them.
Table of Contents
Split Cells in Excel With Flash Fill
A quick means to split the values in your cells right into several cells is by utilizing Excel’s Flash Fill attribute. This instantly removes the worths from your cells and also places them right into separate numerous cells. To use this function, you have to be running Excel 2013 or later on.
To show you how to use this function, we’ll use the adhering to spreadsheet. In this spreadsheet, we’ll divide the names and also marks into numerous cells.
First, click the C2 cell and also by hand kind the name that shows up in the B2 cell. In this instance, it will be “Mahesh.”
Click the C2 cell so it’s picked. After that, in Excel’s bow on top, click the “Data” tab.
In the “Data” tab, from the “Data Tools” area, pick “Flash Fill.”
As well as quickly, Excel will certainly split the names from all the B column records and also include those to the C column.
To divide the obtained marks, click the D2 cell and by hand kind the marks for the B2 cell. In this case, it will be “80.”
Click the B2 cell so it’s picked. After that, in Excel’s ribbon, click the “Data” tab. Select the “Flash Fill” choice as well as all your marks will be divided as well as be offered in the D column.
You’re good to go. If you’re doing a great deal of cell splitting, and also you often need to scroll backward and forward across your spreadsheet, take into consideration using Excel’s split-screen function.
Split Cells in Excel With Text to Columns
Another means to split cells in Excel is to utilize the Text to Columns attribute. In this attribute, you define what divides your worths in your cells, and the feature then uses that separator to divide the contents of your cells.
To show using this function, we’ll once more make use of the very same spreadsheet as the above section:
First, in the spreadsheet, click the cells you want to split into numerous cells. Do not choose any column headers.
While your cells are chosen, in Excel’s bow at the top, click the “Data” tab.
In the “Data” tab, from the “Data Tools” section, select the “Text to Columns” option.
Excel will certainly open up a “Text to Columns Wizard” window. Below, choose the “Delimited” choice and after that click “Next” at the bottom.
On the following screen, in the “Delimiters” section, choose the personality or personalities that divide the worths in your cells. In our example, the values are divided by a comma as well as an area, so we’ll allow both “Comma” and “Space” alternatives.
On the same “Text to Columns Wizard” window, in the “Data Preview” section, you will certainly see what your information will appear like when it’s divided right into multiple cells. If this looks great to you, after that at the bottom of the home window, click “Next.”
On the adhering to screen, click the “Destination” field as well as clear its contents. In the very same area, click the up-arrow icon. You will choose where you intend to conserve the split information.
On your spread sheet, click the C2 cell to store the split data because cell. After that click the down-arrow icon.
Back on the “Text to Columns Wizard” home window, at the bottom, click “Finish.”
And also your single-cell worths are currently divided right into numerous cells.
When you’ve got all your data arranged just how you want it, you may want obtain insights on it making use of Excel’s built-in Data Analyzer tool.
Leave a Reply