Saturday, January 4, 2014

How to divide ‘Text to Columns’ in Microsoft Excel 2007?

Leave a Comment
While working on excel, it may happen sometimes that you need to divide the text in on cell into two columns based on some particular format or fixed length. Doing it manually is a tedious task and takes time. Microsoft Excel 2007 provides us with a feature of ‘Text to Columns’, using which we can divide text in one cell into two columns.

Two ways to divide Text to Columns in Microsoft Excel 2007

1.       Delimited:  In this method, a delimiter in the text is chosen on the basis of which the text will be divided from one cell to two columns. Characters such as commas, tabs separate each field.
2.       Fixed Width:  In this method, we can mark the desired length of the text to be divided.

Steps to create ‘Text to Columns’ in Microsoft Excel 2007

1.       Suppose we have a list of Roll No.’s of the students of the batch 2014 in the following format 101/2014. We need to divide the roll count and year into different columns.
2.       Go to ‘Data’ tab and in the panel click on the ‘Text To Columns’ icon.

3.       A dialog box will appear giving an option to select ‘Delimited’ or ‘Fixed Width’ method to divide text to columns. Let us consider both ways one by one. Select the ‘Delimited’ radio button and click on ‘Next’.

4.       In our text we have ‘/’ as the delimiter from where we need to divide our data. Select the ‘Other’ check box and set delimiter as ‘/’.  Click on ‘Next’ and ‘Finish’.  Text gets divided into two columns on the basis of delimiter.

5.       Similarly follow the second approach and select the ‘Fixed Width’ radio button and click on ‘Next’. 

6.        Select the fixed width of the data using the arrow marker in ‘Data preview’. Click on ‘Next’ and ‘Finish’. Text gets divided into two columns on the basis of fixed width selected.



                                                                                                                

0 comments:

Post a Comment