Splitting columns


show more Splitting columns provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Splitting columns

This list of names and locations has a couple of problems with it. And you could imagine a real life situation with more columns to the right, more about the contact information. If we want to sort this list by last name, we can't do this in the current form. If we want to sort it by State we can't do that either, and we cant sort it by zip code. Essentially, we've got the same problem in two separate columns. What we really need to do here is to split the data into multiple columns. Now you might want to, put that data back together again. That's fine. But let's focus first on column B.

Rather than retyping this, and you could imagine how tedious that could be with thousands of records. Let's select the data and on the Data tab simply use Text to Columns. The key word here is Delimited. There is a character that separates these, and it's pretty apparent that the comma is what terminates the name of the city and of course some cities have two names. Wheat Ridge, ...

Splitting columns
Video duration: 3m 57s 3h 43m Intermediate

Viewers:

Splitting columns provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

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