How to Split Cells In Excel

Yodalearning>Tutorials>How to Split Cells In Excel

Split Cells in Excel is used to split data into multiple columns. Excel text to columns formula technique is used for following:

How to Split Cells in Excel?

As you can see, the First column contains all mix data in one column. We need data in two different columns.

If a cell has got more than just a word for e.g.: First name and surname i.e. the last name. Then, select the cell, range, and the cell containing the text values that you wish to split. You have a long of list of full names as shown below (Example: AbduSalaam, Ismael). You need to split the text into last name and first name into two different columns.

Also, now you can, Transfer Single Columnar Data into Multiple Columns. To know more click here

Split the Data in to two Column with help of Text to Column


You can apply split cell technique. It cuts the data into different columns. Specify the column delimiter i.e. the character where the data must be split. In the example given, the delimiter is a comma, which exists between last name and first name. In the given example, it is clear that full name is in a single column. Separate into two columns. One is the last name, and other is the first name.

Now you can convert or fix digits with trailing minus into negative digits. Check out how by clicking here:

Steps to Split Cells in Excel:

  1. Dataset go to “Data” tab
  2. Click on Text to Columns
  3. Choose the Delimited option. Click On Next button.

  4. Click on Comma button then next button.
  5. Choose Destination cell and Finish.


Please Click here for T2C Hack = Download Now

Result: By clicking on the finish, you will see data got split into two different columns. i.e. Surname in one column and Name in another column.

Solution of Text to Columns

We have solved another interesting query of excel users, in case if you wish to convert an invalid date format into a valid date format.