Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Downloads > Flexfind

Flexfind: Search and replace made easy

For Microsoft Excel

Is free of charge and works in Excel 2003, 2007, 2010, 2013 and 2016.

if you really like it:

Excel 2007-2016

Flexfind2007  v5.3, build 591 (18 Feb 2017, Downloaded: 29,585 times)

This is the 2007, 2010, 2013 and 2016 version, cannot be used with older versions. See below for more information on the tool.

Excel 2003

Flexfind  v5.3, build 588 (27 Oct 2015, Downloaded: 47,087 times) See Screenshot

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: 6,093 times) is still available.

Instructions: Download the zip file by clicking the link above that says "". 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.


Showing last 8 comments of 246 in total (Show All Comments):


Comment by: Jan Karel Pieterse (5/19/2016 7:06:37 AM)

Hi John,

OK got it. I don't understand why that would fool your firewall, but I've made the change.


Comment by: yugi (8/13/2016 7:28:25 PM)

I am sorry for the long question, but i found your tool while trying to change the name of data series in my charts, as i have hundreds of charts changing the name of each data series will take a very long time, so i tried your tool and it found the text i needed to change by choosing objects and values, but the problems that appears are:
1- An error bar in read appears saying that the tool couldn't search in my chart's title and axis texts.
2- When i try to replace the text found with the new text nothing happens even though sometimes the text found changes from 10 entries to 43 entries as if they are duplicated or something.

Sorry to bother you, but its important for me.
Thanks in advance


Comment by: Jan Karel Pieterse (8/15/2016 10:03:53 AM)

Hi Yugi,

Is it possible to email a copy of your workbook to me? (You can strip it down to just one chart with nonsense information but still demonstrating the issue).


Comment by: Gareth Morgan (1/19/2017 4:44:12 PM)

I have a cell reference which is used a lot in 'IF' constructions and a few times in a formula. If I search for A1* then it finds that but also finds A1=, A1> etc.

Is this intentional?


Comment by: Jan Karel Pieterse (1/20/2017 11:48:49 AM)

Hi Gareth,

Replacing things in formulas is tricky, especially in a situation like the one you describe. I guess you'll have to find a common denominator for the search string that does not give you false positives.
If you search for A1*, the tool treats the * as a literal not as a wildcard so only searches for the literal text A1*


Comment by: zystof (2/27/2017 3:17:20 AM)

Had a little trouble setting up with Office 2013, had to manually copy and paste the file to the Add-Ins folder and then also Manually go into Add-Ins through the Excel menu and install it through there, which finally got it working.

Well worth it in the end, found the naughty external link inside some conditional formatting, absolutely saved my life, so thank you very very much!


Comment by: Don (2/27/2017 4:19:11 AM)

Hi, How can I use this to replace texts in header and footer?


Comment by: Jan Karel Pieterse (2/27/2017 10:01:48 AM)

Hi Don,

For starters, check the "Objects" box to enable searching in other things than just cells.


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:

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.