Tips, Tricks, and Answers
The following articles are available for the 'Parsing Data' topic. Click the article''s title (shown in bold) to see the associated article.
Filtering Columns for Unique Values
Given a long list of names, part numbers, or what-have-you, you may need to determine the unique values within the list. The advanced filtering capabilities of Excel provide a very easy way to get the desired values.
Pasting Leading Zeroes
Paste information into a worksheet, and you may be surprised to see leading zeroes disappear before your eyes. Here’s how to get them to stay where you expect them to stay.