As we work on a given data set, it might become necessary that we split the data of one cell into two or more cells. The best example of instances when we need to know how to split cells in excel is when we have a worksheet with employees’ names where we have both the first and last names in one cell.
In such a case, we do not have to keep wondering “How do I split cells in Excel?” in this post, we shall look at how we can easily and quickly split text and numbers in excel.
Procedure
If we have imported data from another source, and want to split cells in excel by delimiter, we can do this in a simple and straightforward way. Think of a situation where we have data with first and last name of employees in one cell. we will be required to split cells in excel first name last name into two different columns so that we can work with the data. To do this, we follow the procedure below;
Step 1: Select the cell or cells that we want to split
The first thing we need to do is select the cell or cells with the data that we want to split in excel.
Figure 1: Split cells in Excel first name last name
Step 2: Head to the Data Tab
The next thing we need to do is head to the data tab, which is among other tools at the top of the Excel sheet or google sheet.
Figure 2: How to split cells in excel
Step 3: Click the text to column tab
Figure 3: Choosing the Text to Column command
Click the “text to column” tab within the data window. A popup window will show up. The popup will be having a text wizard that will guide we if we want to split cells in excel by delimiter or with a fixed width.
Figure 4: Split cells in excel with delimiter
If the data has been separated by a comma or space, choose “Delimited”. Note that we can split cells in excel by data type such as based on comma, space, character or other criteria.
Figure 5: How to split cells in excel based on comma
To split cells in excel based on comma, we need to check the “comma” box in the popup wizard window. After we have selected the criteria with which we want to split the cell, click “Finish” in the wizard, the data shall be split into two or more cells.
Figure 6: Click finish to split cell in excel
If we have data that has three words, then the cell shall be split three time. If it has four words, then it shall be split into four cells and so on.
Figure 7: Split cells in excel
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.
Leave a Comment