|
Similar Data Finder for Excel will help you to find cells with similar values in Microsoft Excel 2000-2007 worksheets. The program enables you to quickly find mistakes made while entering cell values; easily correct the mistakes; find and mark cells which seem to be incorrect; remove the cells with identical values. You can perform the following actions over found similar cells: highlight (change a background or font); clear; change the contents; copy the correct value to every cell of the group; delete the row or column.
One of the important features of the program is its ability to present the cells with identical value in the final report. All the above mentioned operations can be applied to identical cells.
Similar Data Finder for Excel: http://www.office-excel.com/download/similar_data_finder_excel.zip
MAPILab Find and Replace: http://www.office-excel.com/download/find_and_replace_excel.zip
MAPILab Find and Replace for Excel is an advanced and extended version of the "Find and Replace" function for processing data in Microsoft Excel.
In comparison to the standard "Find and Replace" function, MAPILab Find and Replace for Excel has a number of essential benefits:
1. Simultaneous work with several files.
MAPILab Find and Replace for Excel allows you to specify an unlimited number of files and worksheets in which the Find and Replace operation is to take place. You can specify the whole file as well as selected worksheets in it. Using this option you can find and then replace all necessary data in the selected files or documents per one program run.
2. Saving and downloading retrieval requests as templates for reuse.
With the help of MAPILab Find and Replace for Excel you can easily save retrieval requests as templates and then download them in need of repeating this operation. The template stores all necessary information. By downloading the template, you will get a tailored request for search and replacement of data.
3. Creation of an unlimited number of rules for search and replacement of data and their simultaneous implementation.
The standard Find and Replace function allows you to find and replace only one word or phrase per one retrieval of this function. MAPILab Find and Replace for Excel enables you to create an unlimited number of phrases and combinations for search: "a phrase for search - a phrase for replacement".
4. Find and replace operation inside all document properties (formulas, values, comments, hyperlinks etc.).
MAPILab Find and Replace for Excel allows you to find and replace data in the following data sources: cells; formulas; comments; hyperlinks; shapes; headers; footers; worksheet properties. |