This utility helps clean up data in Excel sheets easily.
Excel Data Cleaner Premium is an essential MS Excel Add-In. You need to use commands available in the tool to clean up data automatically by this tool. It is possible to remove extra spaces, digits, alphabets or any text from selected cells or records. This utility will help remove, format and count duplicate & unique entries in excel at high speed. It can do so in less than a minute even when thousands of records are involved. The Data Cleaner is a valuable add-in that helps automate cleaning tasks like duplicate removal, formatting and counting tasks in Excel. Data cleaner is fully compatible with Excel 2000, 2003, 2007, and 2010. Extra spaces and leading spaces in selected cells can be removed. Same goes with trailing spaces, if they need to be removed. Alphabets or numerical data can be removed by this tool from selected columns.
User defined characters also can be removed as can the special characters, if need be. Duplicates can be identified and removed easily. It can help detect unique values and help remove them. It can help remove entries in a given 1st list from another list. Making identification easier, this tool will helps duplicate rows as well as unique rows with specified colors. Duplicate counts can be obtained easily. If you want, the duplicates can be retained in the sheet as well. The interface is intuitive and helps users work quite simply. If you deal with large spreadsheets often, this could be a handy tool. This is a very good tool.