Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Separating Names into Individual Columns You can use the Text to Columns wizard to separate names into different cells. The success you have with this, however, depends on the condition of the original names: You may end up with names in two or three columns. The formulas in this tip are great for figuring out what part of a name goes into which column so that you have a better chance of consistent data after separation. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)