Buy Data Cleaner for Microsoft Excel $49.95 (as at Jan 2005)
The Data Cleaner adds must have features to Excel that automates and eliminates the manually cleaning of data. Save hours of time and insure that all your modifications are done right. The Data Cleaner adds a specialized text replacement feature, a find duplicates feature, a remove blanks feature, a change case feature, and fix number features.
With the Data Cleaner you can:
Create a table of the edit changes you do and have them done automatically. For example, change the entry "ABC Corporation" to "ABC Corp". You can have hundreds or thousands of such data "pairs" and selectively run the ones you want to clean your data. Remove just excess blanks, blanks from just the ends or remove all blanks.
Change the case on words to all upper case, to proper case, capitalize just the first word in an entry, or convert all entries to lower case.
Convert trailing negatives feature converts text entries like 123- or 10CR to negative numbers. A number of programs, most notably SAP, use the trailing negative approach, which this program solves.
Convert "text" numbers to numbers feature is a must for those who have run into numbers that don't act like numbers.
Buy individually or as part of the Analysis Collection for Microsoft Excel. The Analysis Collection gives you downloadable books on Excel macros, this add-in, and over 30 other time saving add-ins. Save over 70% off of individual prices with the Analysis Collection
