With Fuzzy Duplicate Finder you can easily find and correct all sorts of partial duplicate, typos and misspelled words in your worksheets. The add-in performs a fast search for duplicates that differ in 1 to 10 characters and recognizes omitted, excess or mistyped symbols. You can correct misprints automatically or manually directly in search results in your Excel 2000 - 2010 worksheets.
With Fuzzy Duplicate Finder you can:
Quickly find and remove all possible typo, misspelled words and duplicate entries in your Excel worksheets. You can search in a whole list, column or a selected range.
You see all found typos at a glance organized by duplicate groups in a neat pane in the left part of your workbook. You can easily make all possible corrections: remove duplicate, set the right value for all or some duplicates automatically, or correct some of the duplicates manually.
You can split data in each cell into words and process words separately.
You can exclude from search cells or words with fewer than the specified number of characters.
You can choose to correct the same values written in a different case, e.g. Excel, excel, EXCEL, or keep them as they are.
And finally, you can export the results to a separate worksheet for comfortable reviewing.
For more information about Fuzzy Duplicate Finder, please visit http://www.ablebits.com/excel-duplicates-find-remove-addins/index.php.
Changes in this version:
ADDED: - Support for 64-bit version of Microsoft Excel 2010.- Max number of different characters is increased to 10.- A possibility to exclude from search cells or words with fewer than the defined number of characters.
System requirements:
Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, 2003
( By Add-in Express Ltd. - Fuzzy Duplicate Finder for Excel Publisher )