• Home
• Products
  Our Product List New Products Analysis Products Charting Products Data Products Downloadable Books Macro Products Specialty Products Time Saving Products Workbooks and Templates Products by Others Windows Products iPhone Applications
• Download
  Download Information Download Purchased Software Download Upgrades
• Support
  Support Top Support Questions Ordering FAQ's Money Back Guarantee Product FAQ's Online Meeting Excel Problems & Solutions How to Open and Use Excel add-ins How to repair Microsoft Excel
• Excel Solutions
  Charting Solutions Editing Solutions Formatting Solutions Formula Solutions Function Solutions Pivot Table Solutions Printing Solutions Selecting Solutions Toolbar and Menu Solutions Window Solutions Workbook Solutions Worksheet Solutions Other Solutions
• Company
  About Add-ins.com LLC How to contact us Contact Form Customer Feedback Policies License Agreement

Data Cleaner A data related add-in product for Microsoft Excel Order online from our secure service Get delivery in minutes! For Excel 97, 2000, 2002, XP, 2003, and 2007 Order Risk Free - Money back guarantee if not satisfied   $49.95 Buy individually or as part of the Productivity Suite and save!

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 or trim blanks feature removes just excess blanks, blanks from just the ends, or removes all blanks.

• The convert "html spaces" changes a character found on almost all html pages that looks like a space but is not to a true space.

• 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.

• The remove non-keyboard characters feature is an easy way to remove the small boxes and other strange characters that can end up in your data if opened from another computer or a web page. 

• If your data has soft or hard returns in it, the option to remove such characters is easy to use - just select the range to be modified and run the option.  You have the option to just remove the returns or convert to a space or any character.

• The remove any characters feature allows you to specify the characters to be removed and retained in your cell entries.  You select just the characters you want to retain and click the remove button.  Quick select buttons make selection of keyboard characters easy.

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

$49.95

Customers who viewed the Data Cleaner also viewed:

• Duplicate Finder - Quickly find and remove duplicates in one list or between two lists.
• Address Assistant - Easily split addresses in one cell into multiple cells. Fix zip codes needing leading zeros.
• Name Splitter - Easily split names into individual cell entries.
• Multi-Column Sorter - Sort up to ten columns at once!