Text to Columns

Tips, Tricks, and Answers

The following articles are available for the 'Text to Columns' topic. Click the article's title (shown in bold) to see the associated article.

Converting an Unsupported Date Format
If you import data produced by a program other than Excel, it might include dates stored in a format not automatically recognized by Excel. This tip shows how you can do the necessary data conversion so that Excel can recognize the dates.

Fixed-Width Settings when Converting Text to Columns
When you use the Convert Text to Columns Wizard to parse fixed-width data into individual columns, the guesses proffered by Excel on where to break up the data can be wrong. This tip looks at ways you can get rid of the default parsing offered by the wizard.

Separating Names into Individual Columns
If you have a list of names in a column, and you want to separate those names into individual cells, there are several approaches you can take. This tip discusses how you can pull out various parts of the names in your list.