Subscribe in a readerFlexfind: Search and replace made easy
Is free of charge and works in Excel 97, 2000, XP, 2003 and 2007.
if you really like it:Excel 2007
Flexfind2007.zip v5.3, build 566 (14 Jun 2010, 330k, Downloaded: 9782 times)
This is the 2007 version, cannot be used with older versions. See below for more information on the tool.
Excel 97 to 2003
Flexfind.zip v5.3, build 566 (14 Jun 2010, 428k, Downloaded: 35122 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 566:
- Fixed a bug related to searching date values.
Alas, this version will not work on a mac. For Mac users, Flexfind 5.1 (Downloaded: 2956 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.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Comments
Showing last 8 comments of 116 in total (Show All Comments):Comment by: Taurian (4/17/2010 10:47:08 AM)I think flexfind is the tool which I am looking for but I don't know how to configure it. I want to replace words of other language with English words in XLS sheet. Can you please help me ? Is there any site where I can find how to use this tool ?
Regards.
Comment by: Jan Karel Pieterse (4/17/2010 11:41:42 AM)The zip download file contains a manual...
Comment by: Tim (4/20/2010 2:24:41 PM)Dear Jan
I expect you know already but the web page at:
www.jkp-ads.com/FlexfindScreenshot.asp
is not showing the latest version with the button to go back to Excel.
hth
Tim
PS keep up the good work!
Comment by: Jan Karel Pieterse (4/20/2010 10:10:16 PM)Hi Tim,
Thanks!
Comment by: hermine (4/28/2010 2:59:33 PM)Dear Jan
trust you are well
I do not succeed in downloading Flexfind.zip ?( I get an error message)
It works for Flexfind2007.zip
Will it work if we do a file conversion towards excel 2003?
thks for your input and help
all the best
kindest regards
hermine
Comment by: Jan Karel Pieterse (4/29/2010 1:23:33 AM)Hi Hermine,
Yes, if you have the converter, the 2007 version should work just fine. But please try downloading the 2003 version again, it works fine for me.
Comment by: YIM K M (7/25/2010 3:14:05 AM)I have experienced the following error when I tried to find and replace all occurrences of "InBound" in a column of a sheet to "EastBound":
Error 13: 13 in modMain.replace
I would be very much grateful if you can look into this error.
Thanks,
K M YIM
Comment by: Jan Karel Pieterse (8/16/2010 3:07:00 AM)Hi K M,
Can you send me your file please?
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.