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
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.
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.
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