Cell splitting in Excel is a quick and easy way to separate different values or variables written in a cell. Microsoft has provided two different ways for users to do this.
Two features, Flash Fill and Text to Column, are the most important and common methods for dividing cells in Excel; However, other methods may be available to achieve a similar result. In the following, we will explain these two features and how to use them.
Separate cells with Flash Fill
Flash Fill feature allows users to quickly split a cell into several cells. This feature can automatically detect and extract values in existing homes and eventually place them in new homes. To use the mentioned method, you must use the 2013 version of Excel software or newer versions.
To illustrate how to use the Flash Fill feature, we will use the following spreadsheet as an example where each person’s letters and scores are written together.
Set cell B2 to the selected state and click Flash Fill again from the Data tab. All numbers will now be transferred to column D.
If you want to create a lot of new cells, you may need to scroll the page frequently. In such cases, using the built-in Split Screen feature of Excel software can be useful and practical.
Divide cells in Excel with Text to Columns
Text to Columns capability is another method for separating cells in Excel that can be used to define the type of values to be separated. To learn how to use the said feature, we will use the spreadsheet of the previous example again.
The Text to Columns Wizard window will now open automatically. In this section, select the Delimited option as shown below, and then click the Next button.
On the next page, in the Delimiters section, you can define one or more characters that separate different values within cells. In this example, the values are separated by commas (,) and the space after them; As a result, select both Comma and Space in the Delimiters section.
Under Data Preview you will be able to see a preview of the cell division result in Excel. If the preview output is good, click Next to go to the next page.
The third step of the Text to Column feature is related to defining the destination of the cell separation. Click on the Destination section and delete the values in it. In the same area, click on the bookmark icon in the right corner to specify where to store the isolated data.