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
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.
Steps to Split Cells in Excel:
- Dataset go to “Data” tab
- Click on Text to Columns
- Choose the Delimited option. Click On Next button.
- Click on Comma button then next button.
- Choose Destination cell and Finish.
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.