Yodalearning>Tutorials>How to do Text to Columns in Excel

8 Excel Challenges to Know How good you are at excel ? To know more Download Now

Text to Columns in Excel or Split Cells in Excel is used in data cleaning and data re-arrangement. Excel text to columns formula technique is used for following:

How to do Text To Columns In Excel?

Split the text as last name and first name 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 in 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 Text to Column technique or 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 below, 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:


Quick and Simple Steps For Text to Columns in Excel:

Result: By clicking on the finish, you will see all the surnames in one column, and the name is 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.

Click here: You can also use text to column in excel VBA, to get excel VBA tutorial you need to enroll to our course Split Cells In Excel | Text To Columns | Excel Split Column into multiple columns | Multiple columns Split in excel tutorials