Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles split cells How to split a cell in Google sheets and excel

How to split a cell in Google sheets and excel

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

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc