2007 Microsoft® Office System Plain & Simple

Separating Data into Columns

You might find that some data has been collected in a way that isn’t designed for what you want to do with it. For example, let’s say you have a mailing list in which people’s first and last names are lumped together in one column. What do you do if you want the first name in one column and the last name in a second column? Easy! You just tell Excel to divide this type of information into separate columns.

Separate the Data

1. Select the data that is to be separated.

2. On the Data tab, click the Text To Columns button to start ...