Flexfind: Search and replace made easy
What is FlexFind
Flexfind eases searching throughout an entire Excel 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).
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 header of 6 sheets? Or in your VBA macro's? Flexfind enables you to do so.
Flexfind is free of charge and works in Excel 2003, 2007, 2010, 2013, 2016, 2019, 2021 and 365 both 32 and 64 bits.
Donate
If you really like Flexfind, please consider donating to help support it's future development:Downloads
Please read: Excel add-ins fail to load
Current versions of Excel (Windows and Mac)
Flexfind v5.3, build 626 (Juli 31, 2024, Downloaded: 92.767 times)
This is the version for all versions as of Excel 2007, including Mac Excel (beta).
This version cannot be used with versions prior to Excel 2007.
Old Mac version
For Mac users having issues with the 2007 version above, Flexfind 5.1 (Downloaded: 8.894 times) is still available.
Excel on-line
Here is a version of Flexfind which works in Excel on-line.
Recent Changes
5.3 Build 626: The tool now displays found cell addresses without $ signs.
Installation Instructions
Download the correct zip file using the links above. 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.
Comments
Showing last 8 comments of 294 in total (Show All Comments):Comment by: Jan Karel Pieterse (28-5-2024 16:55:00) deeplink to this comment
Hi Rico,
I've found the problem with the # sign and updated Flexfind to build 625.
Please download the add-in from my site again and replace your copy with the new one.
Comment by: Rino (28-5-2024 17:11:00) deeplink to this comment
It worked!! Thank you very much!! You saved me A LOT of time!!
Comment by: Rino (29-5-2024 23:31:00) deeplink to this comment
I've got another little issue. If I try to search text in a formula, it shows nothing.
All these formulas are basically links to a specific cell in a specific workbook on my LAN, for example:
='Z:\accountants\2022\[year2022.xlsm]name_of_the_sheet'!$D$87
I would change the 2022 value, but I can't find it (tried objects, values, formulas).
Do I miss some search criteria for this type of inquiry?
Thanks Jan!
Comment by: Jan Karel Pieterse (30-5-2024 16:12:00) deeplink to this comment
Hi Rino,
Odd, it works just fine for me.
Comment by: Rino (31-5-2024 08:21:00) deeplink to this comment
Hi Jan, thank you for your response.
Could it be a matter of lenght of formulas? They can be more than 160 charcters long
Comment by: Jan Karel Pieterse (3-6-2024 10:24:00) deeplink to this comment
Hi Rino,
Are you able to share that file? All I would need is a single-sheet workbook containing just one formula that demonstrated the issue. You can send it to me using the email address at the bottom of the page.
Comment by: Allan Penderis (19-10-2024 12:11:00) deeplink to this comment
Good day Jan Karel, is a version of Flexfind suitable for Excel 2003 still available? Thank you, Allan
Comment by: Jan Karel Pieterse (19-10-2024 12:18:00) deeplink to this comment
Hi Allan,
I suppose the one under "Mac version" should work?
Have a question, comment or suggestion? Then please use this form.
If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.