Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to parse data using the Text To Columns command in Excel
Article ID: 214261 - View products that this article applies to.
This article was previously published under Q214261
This article contains information about how to parse data in Microsoft Excel by using the Text To Columns command.
If you copy data from another program and paste it into Microsoft Excel, Excel may condense several columns of data to a single column. You can use the Text To Columns command on the Data menu to put each record in a separate column. The range that you convert may contain many rows, but you can only convert one column of data at a time.
To create an example that demonstrates how to use the Text To Columns command:
Note The example illustrates data with commas as the delimiter. This is only one of several delimiters that you may see in your data. For example, if you have Names in a column of data, consisting of first and last name in a single cell separated by a Space, the Space character can be used as a delimiter to separate the first and last names into adjacent cells instead of the same cell.
A1: The,dog,ran B1: The C1: dog D1: ran A2: abc,def B2: abc C2: def A3: abcdefg,hijkl B3: abcdefg C3: hijkll A4: 2554,4874,41 B4: 2554 C4: 4874 D5: 41
For more information about parsing data, click Microsoft Excel Help on the Help menu, type parse data in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Article ID: 214261 - Last Review: September 18, 2011 - Revision: 6.0