Flexfind: Search and replace made easy

For Microsoft^® Excel^®

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 562 (12 Jan 2009, 330k, Downloaded: 6283 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 562 (12 Jan 2009, 428k, Downloaded: 24361 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:

Redesigned the user interface
When selecting multiple found items, Flexfind will try to create a multiple selection of the areas found.

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

Comment by: Mark (1/19/2009 11:25:38 AM)

Can this be used to edit the path for chart data?

Comment by: Jan Karel Pieterse (1/20/2009 2:25:36 AM)

Hi Mark,

Yes, it should work (though in some cases it seems to fail, due to bugs in Excel). Just open a copy of your file and try it.

Comment by: Doug (2/4/2009 2:37:41 AM)

I use many charts in excel 2003. I have found a add-in
that will update chart ranges for an entire worksheet.
If anyone knows of a add-in that will change the scale
in graphs for an entire worksheet in one shot, could you
email me at douglasrburns@aol.com.
Thank You

Comment by: nick bob engels (3/17/2009 8:13:16 AM)

this thing saved my life and extends every vacation

Comment by: Nivaeh (4/24/2009 11:31:20 AM)

I'm looking for something that will allow me to find and replace standard character in an excel spreadsheet with a non-standard, specifically a carriage return.

Will this do that?

Comment by: Jan Karel Pieterse (4/25/2009 10:30:38 AM)

Hi Nivaeh,

It should do that yes. You simply enter the special character somewhere (e.g. in a cell) and copy it. Then you paste it into the replace boc using control+v.

Comment by: Hugh Stevenson (5/30/2009 10:37:50 AM)

Thanks, Jan!
I'm having the same problem as Nivaeh. In Excel, you can enter Alt-0010 to specify carriage return as the replacement string. This doesn't work in flexfind, and I was unable to make your suggestion work, either.

Comment by: Jan Karel Pieterse (5/30/2009 10:38:36 AM)

Hi Hugh,

Indeed it does not seem to work. I'll have to look why.

Have a question, comment or suggestion? Then please use this form.

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