Free Excel Tutorial for Engineers : Text to Column

It may be observed that while copying from text or CSV file into excel, all the lines are saved in a single column. In such cases, to distribute the data in different columns we can use the text to column function.To use the text to column option, select the column, go to the data tab and select the text to column option. In the dialog box, check on the delimited option and click on next. From the option provided select the separators based on which you need to distribute the data. From the next screen select the format in which you need the data and click finish. The text will be distributed in different columns. This feature is very useful for converting data from CSV Files and bringing data from other documents into excel.