|
Microsoft Office Application Development
|
|
FlexfindIs free of charge and works in Excel 97, 2000, XP, 2003 and 2007. if you really like it:Excel 2007Flexfind2007.zip v5.3, build 559 (1 Apr 2008, 330k, Downloaded: 3154 times) This is the 2007 version, cannot be used with older versions. See below for more information on the tool. Excel 97 to 2003Flexfind.zip v5.3, build 559 (1 Apr 2008, 428k, Downloaded: 18899 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:
Alas, this version will not work on a mac. For Mac users, Flexfind 5.1 (Downloaded: 1935 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. CommentsShowing last 15 comments of 43 in total (Show All Comments):Comment by: Jan Karel Pieterse (10/28/2007 10:51:50 AM)Hi Susan, I'd be happy to help, if you send me some more details by email. See my contact page. Comment by: Kanwaljit Singh Dhunna (11/10/2007 10:55:45 AM)Hi Jan, Would love to see the version date in "About" screen. Thanks CA Kanwaljit Singh Dhunna Comment by: kanwaljit Singh Dhunna (11/15/2007 3:26:29 AM)Hi Jan, The "List" commandbutton is half visible when the User form opens up at first. Regards Kanwaljit Singh Dhunna Comment by: Sri (1/30/2008 2:09:57 PM)Can I use flex find with Power Point? I need a tool to find & replace text in Chart titles across graphs created in PowerPoint? Thanks. Comment by: Jan Karel Pieterse (1/30/2008 10:16:55 PM)Hi Sri, No, Flexfind is an Excel addin. So only if your charts are embedded Excel charts, you might be able to do this by opening the charts in excel. If they are in separate workbooks this will become unwieldy. Comment by: vicky (2/27/2008 4:42:29 AM)hello i am looking to do a simple search can your tool thingie help me????? an soo i will be needing to do a complex search! any idias? can you help??? write back asap plz xx Comment by: Jan karel Pieterse (2/27/2008 5:29:11 AM)Hi Vicky, It is quite likely Flexfind will do what you need, just try! Comment by: Don (3/3/2008 1:22:55 PM)Looking to replace one cell of text with a list of text in serveral cells. Will this add-in do that? Comment by: Jan karel Pieterse (3/3/2008 10:23:54 PM)Hi Don, Depends what you need exactly. You can type the replacement text as it appears in the multiple cells, but it has no way to paste multiple cell content into the replacement box directly. Comment by: Gene (3/10/2008 11:58:53 AM)Will this tool allow me to enter a string in the cell immediately to the right of the occurance of several different strings in a worksheet? Comment by: Jan karel Pieterse (3/11/2008 2:34:26 AM)Hi Gene, No, unfortunately it does not allow you to do just that. Comment by: Amit (3/22/2008 1:34:01 PM)Amazing help.... Thanks a ton !!! Comment by: Steve E. (3/27/2008 2:34:27 PM)Jan, great add-in, thanks for the work. Comment by: diana (4/18/2008 1:05:39 PM)I need to replace dates from one sheet to another sheet. Example: I copy an entire sheet to another sheet but I want to change 8-Feb to 7-Mar. wherever 8-feb occurs. Please advise, the version I use is Windows XP Professional 2003 Comment by: Jan Karel Pieterse (4/21/2008 7:46:29 AM)Hi Diana, I'd first copy the sheet and then just do a search and replace (control+h) to replace the dates. Add a comment too!!!Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. | ||||||||||||||
Use the contact page to issue
questions or comments about this website. |