ExcelSmartTools DataClean was developed for helping users to edit, to correct and to clean spreadsheets, lists and reports importers.

Excel Software Tools

ExcelSmart Tools Data Clean

Now Only $35.00 Purchase Now

Features:

For the Microsoft Excel normal user, the major commands available allows to:

Correct formulas that return errors, as for instance the division for zero
Verify that all the cells are of the same type of data (for instance, dates, formulas, labels
Convert text for upper letters, lower cases

For users that work with imported reports from ERP ( like AS400) , the most important commands allow, besides mentioned previously:

To eliminate spaces in excess
To correct negative values (125 -) for the correct value in Microsoft Excel -125
To convert Numeric Text for numbers, that can be used by mathematical functions in the spreadsheet
To convert thousands and decimal separator for the separators used by the spreadsheet (and configured in the Control Panel)
To convert imported dates to the format of dates used by the spreadsheet

For users of lists, the key commands allow, besides mentioned previously:

To edit and to correct values of lists, allowing correcting several values simultaneously
To extract a sampling of the data, using three methods different from samplings
Shade the list