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.

Trainings

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

Third party tools

Speed up your file

FastExcel
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 590 (21 Apr 2016, Downloaded: 28,766 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: 46,869 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 589:

Added support for the firstpage headers and footers.

Alas, this version will not work on a mac. For Mac users, Flexfind 5.1 (Downloaded: 5,943 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.


Comments

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

 


Comment by: john (5/18/2016 9:37:02 AM)

Could you remove the ".zip" from the download links above? Our corporate firewall allows me to download Name Manager but not Flexfind and I believe it is because of this.

Thanks

 


Comment by: Jan Karel Pieterse (5/18/2016 10:08:54 AM)

Hi John,

I'm afraid I cannot do that as many other users would be adversely affected because Windows doesn't know what program to use to open the downloaded file.

 


Comment by: john (5/18/2016 10:13:19 PM)

Thanks for your quick response. I think that you misunderstood me. I am not asking for the filename extension to be removed from the file. I am asking to remove ".zip" from the link on the web page. It would then be like the Name Manager page which does not mention ".zip" in the link to download.

Thanks

 


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*

 


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.

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.