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,632 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,454 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,382 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 255 in total (Show All Comments):

 


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!

 


Comment by: Wouter Mense (8/22/2017 3:57:39 PM)

Hey Jan,

Can this also find&replace in named range names (so not the .RefersTo but the .Name)? So far it doesn't seem like it does, but would be a nice feature!

 


Comment by: Jan Karel Pieterse (8/22/2017 4:05:26 PM)

Hi Wouter,

No it cannot, but you can use Name Manager for that.
http://jkp-ads.com/officemarketplacenm-en.asp

 


Comment by: Wouter Mense (8/22/2017 4:13:57 PM)

Well, yes, it can be done with Name Manager, which is what I'm doing now, but only by manually editing the names one by one. Unless I'm overlooking something obvious? There is the Find&Replace in RefersTo button (requires FastExcel, unlike FlexFind?), but nothing similar for the names themselves.

 


Comment by: Jan Karel Pieterse (8/22/2017 4:35:50 PM)

Hi Wouter,

There is some sample code in the manual to do a mass-rename of names using Name Manager...

 


Comment by: Wouter Mense (8/23/2017 10:22:46 AM)

Hi Jan,

Thank you! This will save me some time going forward. Of course I could have read the manual first but after using the addin for so long I guess I got cocky :) In the meanwhile I've done all the renaming manually but since it's a recurring workflow I'll just plug that code somewhere in my personal worksheet for later use. Thanks again for your help :D

 


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.