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).

Flexfind add-in for Excel

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 621 (August 30, 2023, Downloaded: 91.610 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.685 times) is still available.

Excel on-line

Here is a version of Flexfind which works in Excel on-line.

Recent Changes

5.3 Build 621: Improved the report created by clicking the List button

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 283 in total (Show All Comments):

Comment by: Keith Bales (18-12-2021 23:27:00) deeplink to this comment

When I updated FlexFind build 590 to build 601 in Microsoft 365 Excel and now I'm getting the dreaded "Cannot run the macro 'FlexFind2007'. The macro may not be available in this workbook or all macros may be disabled." I thought I was able to fix this on previous installations but can't get FlexFind to open no matter what I do with Options, Trust Center Settings, et al.

Comment by: Jan Karel Pieterse (19-12-2021 11:48:00) deeplink to this comment

Hi Keith,

https://jkp-ads.com/Articles/Excel-Add-ins-fail-to-load.asp

Comment by: Drew Smith (4-5-2022 19:58:00) deeplink to this comment

Followed all instructions, including checking regedit, but get an error message: Error 453: Can't find DLL entry point FindWindowA in user32 in modMain.FlexiFinder. Fails to load. Any suggestions, please?

Running Windows 10 BTW

Comment by: Jan Karel Pieterse (5-5-2022 10:27:00) deeplink to this comment

Hi Drew,

I've had one other report of this (for a different add-in), but we've never been able to resolve that matter. If it's OK, I'll send you a test version to see if we can resolve this.

Comment by: Jim Spielman (11-1-2023 16:18:00) deeplink to this comment

I have 18 workbook tabs with 9 graphs per tab. I need to move the data source forward one month each month, so the graph shows the month-by-month forward 12-month period line over the month-by-month trailing 12-month period line (esentially the monthly forward 12-month revenue forecast over the trailing 12-month actual revenue performance.

After each month-end close, How can I update these graphs (in bulk) so that the graph data is pulling from the new period ranges?

Comment by: Jan Karel Pieterse (11-1-2023 17:29:00) deeplink to this comment

Hi Jim,

I would do it like this:
- Insert a new blank sheet
- Add formulas to that sheet which fetch the data you need for each chart
- Make sure those formulas are dynamic: that they somehow allow you to select a period and that these formulas then pull the data from the right worksheets. You might want the INDIRECT function for that.
- Have the charts point to the formula ranges of this new sheet

If you set this up correctly, next time all it takes is choosing the right period on your newly inserted sheet.

Comment by: Dan (8-2-2023 21:41:00) deeplink to this comment

Hi, the replace function doesn't preserve formatting. I have found a macro that will find and replace (including insert line breaks) and preserve formatting, but only for cells up to 256 characters. Do you have a solution for cells with more text in them. (Also, I couldn't get _Chr(10)_ to work in the replace field: am I missing something?
Thanks

Comment by: Jan Karel Pieterse (9-2-2023 11:12:00) deeplink to this comment

Hi Dan,

Despite the text in the manual, _Chr(10)_ must be in lower case:
_chr(10)_

In addition, there is a bug in the code so it does not work.
I'll update the tool soon and let you know.

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.