Excel Search and Replace is a freeware macro for Microsoft Excel. We created 'ExcelSR' for those who need to search (and replace) in Excel documents but find Funduc's Search and Replace too powerful for your purposes. Excel Search and Replace uses the find and replace functions built-in to Microsoft Excel. It does not use our Search and Replace product so your available functions are the same as those present in the Excel 'Find and Replace' dialog. Excel Search and Replace can process more than one file by specifying a 'wild card' in the dialog 'File Mask (with path)' field.
Please look below for version-feature information.
We have counterpart macros for MS Word (Word SR) and MS PowerPoint (PwrPt SR).
Excel Search and Replace Dialog
Please click the Close button the first time you open 'ExcelSR.xls' and read through the text in the file for usage information. Also review the 'ReadMe.txt' file in ExcelSR.zip.
Excel Search and Replace requires that you have macro functioning turned on. You may need to enable Excel macros in your Options settings if macros are disabled.
Scan the file (ExcelSR.xls) with your anti-virus scanner before you open the file for the first time.
Excel Search and Replace can only process files understood by your Excel installation. .xls files are understood by default. Whether you can handle any other file types depends on the conversion features installed for your Microsoft Office. Consult the Office Assistant for more information on conversion functionality.
Back up your files first. Do NOT rely on the Excel 'undo' function. Excel Search and Replace writes a file named 'ExcelSR_Results.txt' in the same path that the operation is performed in. This file summarizes the search results or changes made. However, there is no built-in backup functionality.
See the 'License' section in ExcelSR.xls for distribution information. You are free to modify the VBA code in the macro. If you like, send any changes you make to email@example.com. If your changes can benefit others we will add them to a new version. Thanks.
Version 2.0 - A 'Find' function was added.
Version 1.5 - Internal release.
Version 1.2 - Internal release.
ExcelSR.zip (Ver 2.0 - 45K) - Unzip this into the subdirectory of your choice. See 'readme.txt' for more information.