| On this page: Download | Upgrade | Buy |
Screenshot | View help file |
PATools Advanced Find and Replace works in a similar fashion to the built-in Find and Replace features in Microsoft® Excel® software, except that now you can
- search and replace throughout multiple open or closed workbooks
- easily work with special characters such as tab, asterisk, question mark, line feed (input as ALT+ENTER in a cell), etc
- get a full history of formulae before and after, by using the Tracking facility
- get a summary of how many were found and/or replaced in each worksheet
Each time you run a find or replace a summary text file is created in your temporary file folder (eg c:\windows\temp). This file logs a summary count of the results per worksheet, and logs any errors encountered.
In addition the Tracking facility will create a new spreadsheet in which it will record the workbook, worksheet, cell, and cell formulae for find/replace. This workbook will be given a unique name and saved in your temporary file folder (eg c:\windows\temp).
These files are available for copying to a folder of your choice. In addition you can view the last one created at any time from the software interface.
Click to see full size screenshot
By installing and using this software you affirm your complete and unreserved acceptance of the PATools
End User License Agreement
For new users, the software will run on an evaluation basis, which means that you can use it for as long as you wish but it will search in only 3 worksheets per workbook.
You can purchase a license 24/7 using our secure automated service from this webpage below.
Changes since last release
Upgrade
No need to uninstall your current version - simply download as above and unzip over the top of your current version.
Users who installed using the Installation Workbook method in the past will find the current version under C:\Program Files\PATools Software\... unless you chose a different location during the Installation.
Contact us if you have problems.
Buy
BUY NOW from the secure ordering site of our payment partner share-it! where you can pay in various currencies
Licenses expire after 1 year.
SAVE MONEY by buying an extended license (lasting more than 1 year) - see here
SAVE MONEY by buying several PATools Excel products - see here