Converting text to columns


show more Converting text to columns provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Converting text to columns

Sometimes when you're working with lists, the information that's included in a particular column could really be broken out into two columns to make it a little bit easier to sort through. We have an example of this here in column A, where our item description is really a mixture of the exterior category and the item type together. What I'd like to do right now is to break those two out into two separate columns, so that I can sort all the information in a much easier fashion. to do that I need to move over to my Data tab, and a I need to allow for an additional column in my data.

First thing to do is I want to add a column right here in column B. I select column B, to identify where I want to put that that new column, right-click and select Insert. And the information is pushed aside so that I have now a nice, new column in order to work with. The next thing I want to do is I want to select the column that I'm interested in working with, and I go to the Text to Columns comma...

Converting text to columns
Video duration: 3m 10s 5h 13m Beginner

Viewers:

Converting text to columns provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...