Tips.Net > ExcelTips Home > Data Entry > Parsing Data
Tips, Tricks, and Answers
The following articles are available. Click the article's title (shown in bold) to see the associated article.
Filtering Columns for Unique Values If you have a worksheet column containing lots and lots of data, you may want to extract the unique data it contains. Using the advanced filtering capabilities of Excel, this task is much easier than you’d think. Microsoft Excel versions: 97 2000 2002 2003
Pasting Leading Zeroes When you paste data that contains leading zeros into a worksheet, those zeros are normally dropped by Excel. If you want to retain the zeros, you’ll need to format the cells properly before you do the pasting. Microsoft Excel versions: 97 2000 2002 2003
Problems with Dates?
No, not that type of date. If you need to do any types of work with calendar dates, Excel has the tools you need. Learn how to use those tools the easy way. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Great Info!
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)