Data Cleaner

Data Cleaner adds must have features to Excel that eliminate the manually cleaning of data. Save hours of time and ensure that all your modifications are done right. The Data Cleaner adds the following features:

The replace/ modify text feature works off of lists you build so that you can easily modify data. For example, your data can contain the entry "ABC Corporation" and you want to change it to "ABC Corp". You can have hundreds or thousands of such data "pairs". Also you have a number of search and replace options to provide the control you need to modify your data.

The remove blanks feature removes just excess blanks, blanks from just the ends, or removes all blanks.

The change case feature changes the case on your words to all upper case, proper case, capitalize just the first word in an entry, or convert all entries to lower case.

The convert trailing negatives feature converts text entries like 123- or 10CR to negative numbers. A number of programs most notable SAP uses the trailing negative approach which this program solves.

The convert "text" numbers to numbers feature converts cell entries that look like numbers but behave like text strings back into numbers. This problem is often encountered when you import data from other programs.

If you are in need of finding and removing duplicates then checkout the companion product the Duplicate Finder.

Order online from our secure service.
Get delivery in minutes!

$49.95

Copyright 2008 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC.
Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation.