Flexfind: Search and replace made easy
Is free of charge and works in Excel 2003, 2007, 2010, 2013 and 2016.if you really like it:
Flexfind2007 v5.3, build 591 (18 Feb 2017, Downloaded: 29,012 times)
This is the 2007, 2010, 2013 and 2016 version, cannot be used with older versions. See below for more information on the tool.
Flexfind eases searching throughout an entire workbook. Enter a string to search for and get a list of all found locations. Click on an entry to go there. Select workbook, sheet or range searching. Replace with another string in the found items you select. At your wish, get a confirmation for each occurrence found (also within one cell). MAC enabled (thanks to Matthew Henson). Ever needed to replace a company name in the title of 25 charts? Or replace just the third occurrence of a cell address in some cells' formulas? Or change a part of the printheader of 6 sheets? Now there is Flexfind, which enables Search and Replace in all these items and more!!!
Changes in 5.3 Build 591:
Added support for replacing in Powerquery M code (Excel 2016).
Alas, this version will not work on a mac. For Mac users, Flexfind 5.1 (Downloaded: 5,974 times) is still available.
Instructions: Download the zip file by clicking the link above that says "Flexfind.zip". Unpack the files in the zip file to a folder of your liking and open the file called "Setup Flexfind.xls". Press the button in that file to install.
Click here to request support or issue comments or suggestions on this product.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.