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
Excel makes it easy to import information created in other programs. Converting the imported data into something you can use can present a challenge. Here's how to make a change from an unsupported date format to one that Excel can work with.

   Fixed-Width Settings when Converting Text to Columns
The Convert Text to Columns capabilities of Excel are very helpful when pulling apart information. When working with fixed-width data, you may want a way to "override" what Excel suggests as breaking places for the data. Here are some ideas.

   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.

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.