Advanced Excel Find & Replace is an add-in for Microsoft Excel 2000, Excel XP (2002) and Excel 2003. It enhances Excel's built-in Find and in addition to all features of the built-in Find allows simultaneous search in values, formulas and comments, search in all opened or selected worksheets and workbooks, free moving around search results, and replacing values in found items. This Excel add-in reduces the number of clicks to one and the search time to a second and adds no new workbooks or VBA macros to your Excel.
All possible manipulations inside the list are allowed:
- you can select the items of interest (or all found items);
- you can replace values in the selected or all items;
- you can search for other values in the selected or all items.