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 592 (7 June 2017, Downloaded: 30,387 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,366 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 592:

Flexfind now defaults to searching only in the active workbook.

Alas, this version will not work on a mac. For Mac users, Flexfind 5.1 (Downloaded: 6,323 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 250 in total (Show All Comments):

 


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.

 


Comment by: Dennis Swaney (6/2/2017 5:49:15 PM)

Jan,
When I downloaded Flexfind v 5.3 build 591, it says it is build 590. Is the download link on the website to the most current version?

Thanks,
-Dennis Swaney

 


Comment by: Jan Karel Pieterse (6/6/2017 6:19:45 AM)

Hi Dennis,

Thanks for letting me know, I forgot to change the build number in the tool so you are using the 591 build. I have now updated the number in the current download.

 


Comment by: Wouter Mense (7/12/2017 8:50:36 AM)

Hi Jan,

I've got some issues with resizing the search window and columns. Once I've resized the window, if I touch any of the column adjusters, the search result panel will randomly reducing its size. After this there's nothing I can do to restore the window to "normal". Aditionally, FlexFind remembers the window size between loads, but only until I restart Excel.

 


Comment by: Jan Karel Pieterse (7/12/2017 10:40:06 AM)

Hi Wouter,

Thank you for rporting this issue!

 


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.