Data Cleaner Add-In for Microsoft Excel

Data Cleaner | Microsoft Excel Add-Ins

Data Cleaner Add-In for Microsoft Excel

Clean and replace unwanted text characters in your worksheet data.

Data Cleaner allows you to rapidly clean and replace text in your data on your worksheet that cause your formulas and Excel's data tools so much trouble.

About Our Data Cleaner Add-In for Microsoft Excel

New Excel Add-In

Version: 9.0
Excel Versions:
2007 and Above
Windows Version: 7.0 and Above
Status: Coming Soon

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.

LinkedIn
Facebook
Information
Need Help? Please call us at 1.866.924.6244

Copyright © 2002-2017

EMAGENIT All Rights Reserved