If you ever realized the pain of doing searching and replacing data in your huge spreadsheets, you will highly appreciate Search and Replace. It is a tool to search and replace many spreadsheets at the same time. For e.g. You need to change your office address at all the locations it is present, then you can do this with this software. It has the automation feature to run overnight or over a weekend, and it takes care of passwords, protection, locked fields, and read-only files etc.

If you compare ExcelPipe with Microsoft Excel, ExcelPipe offers many search and replace options that are not available in Excel. E.g. bookmark, hyperlinks, drop down fields, etc. Now you can search/replace inside Chart Titles and Defined Names. It is fully Unicode compliant - search and replace international character sets and allows replacements to be longer than 255 characters.

ExcelPipe Search and Replace is easy to install/uninstall. But it has its own limitations. Speed for massive Hyperlink changes is limited. Hyperlink changes can not automatically check for equivalence between %20 and space.