Monday, 23 April 2018

MS Excel: How to Convert Text into Separate Columns (Easy)

MS Excel: How to Convert Text to Column (Easy), text to column in excel, how to separate text & number in excel, text & number convert to separate cell, convert data to separate cells, excel 2007, excel 2010, excel 2016, data converter, divide to separate column, How to Convert Text into Separate Columns, 2018, excel tips & tricks, flight number, date, sl. No. pan number, separate number & text, text to column convert, Hi guys; today I back with MS Excel tips & tricks; in this article we will learn how to convert text into separate columns, there might be other different methods & tricks to do this, but here I will shows you one of the easiest way to do this, just follow below steps.

1.     Select your data click on “Data”“Text to Column” check on “Fixed width” than “Next”
MS Excel: How to Convert Text to Column (Easy), text to column in excel, how to separate text & number in excel, text & number convert to separate cell, convert data to separate cells, excel 2007, excel 2010, excel 2016, data converter, divide to separate column, How to Convert Text into Separate Columns, 2018, excel tips & tricks, flight number, date, sl. No. pan number, separate number & text, text to column convert,

2.       Select your data length and “Next”
MS Excel: How to Convert Text to Column (Easy), text to column in excel, how to separate text & number in excel, text & number convert to separate cell, convert data to separate cells, excel 2007, excel 2010, excel 2016, data converter, divide to separate column, How to Convert Text into Separate Columns, 2018, excel tips & tricks, flight number, date, sl. No. pan number, separate number & text, text to column convert,


3.       Click on “Destination” box, keep the courser on blank cell and click on “Finish”
MS Excel: How to Convert Text to Column (Easy), text to column in excel, how to separate text & number in excel, text & number convert to separate cell, convert data to separate cells, excel 2007, excel 2010, excel 2016, data converter, divide to separate column, How to Convert Text into Separate Columns, 2018, excel tips & tricks, flight number, date, sl. No. pan number, separate number & text, text to column convert,


Watch video tutorial… Please like, share & subscribe 

No comments:

Popular Posts