Excel Training, Excel VBA Training, Excel Software Design

Data Cleaner for Microsoft Excel


Data Cleaner for Microsoft Excel

Microsoft Excel Add-In Version 9.0

Clean and replace unwanted text characters in your data.

About Data Cleaner

For: Excel versions 2007 and above; Windows 7.0 and above

One of the most difficult data processing problems faced by Microsoft Excel users today is that worksheet information comes in corrupted. Our Microsoft Excel Add-In Data Cleaner helps you with this problem allowing you to search through data in a worksheet replacing specific characters in worksheet cells or deleting them. Using Data Cleaner the following tasks can be performed:

  1. Search All Scan: Searches all the text in a cell and either replaces or eliminates the characters your specify at any character position in the cell.
  2. Left-Hand Side Scan: Searches only the left-hand side of your cell text eliminating characters that you specify. The characters would have to start at the first character on the left-hand side.
  3. Right-Hand Side Scan: Searches only the right-hand side of your cell text replacing or eliminating characters that you specify. The characters would have to start at the first character on the right-hand side.
  4. Position Scan: This allows you to specify the exact character within the cell text counting from the left-hand side to replace or eliminate
  5. Space Scan: This scan allows you to delete front and rear spaces around your cell text and makes the spacing between words in your cell a uniform single space, a huge problem with typed data
  6. Non-Printable ASCII Scan: This scan allows you to remove non-printable ASCII characters from your cell text, a huge problem with downloaded data

Data Cleaner uses our active cell technology. This means you can launch Data Cleaner, leave it open and maneuver around in Microsoft Excel without closing it. Data Cleaner is viewed as a floating dialog box, not a Ribbon tab, which means it follows you around the screen and avoids the annoying Ribbon trip to activate its features. Data Cleaner is also smart and allows you to save multiple tool configurations allowing you to rapidly reconfigure the tool based upon the worksheet that you are currently working on.

At EMAGENIT, we are always looking to improve our add-ins so if you have a particular capability you would like to see added to Data Cleaner, click on our suggestion link and let us know. Make a suggestion.

Available: Coming in February



Site Map

Copyright © 2002-2017

EMAGENIT All Rights Reserved