Excel Search and ReplaceTool is a useful tool developed to carry out Find and Replace and formatting tasks in multiple excel files with precision. Purpose of this software is to save time and effort of the user by performing find and replace and formatting tasks in multiple selected excel spreadsheets at one go. The user can perform these tasks following simple steps. Most operations can be carried out with a few clicks of the mouse. The user first needs to add files by clicking ‘add files’ or ‘add folders’ button. After clicking on ‘add files’ button user can simply select files to be added. On clicking ‘add folder’ button all files contained in the selected folder are automatically added. Users have the option to remove selected files also. Thereafter user needs to click ‘add words’ button to go to next step and enter words and phrases in ‘Find what’ and ‘Replace with’ boxes and perform Find and Replace tasks effortlessly.
The user has the liberty to perform these operations in single or multiple files. Batch find replace feature provided in the software allows the user to find and replace words and phrases with the help of wildcard utility in all types of excel files like XLS, XLSX, XLSM, XLT etc. Apart from these features a log file is also provided. It gives all information about Find and Replace and Formatting tasks performed. The tool supports files in different formats like XLS, XLSX, XLSM, XLT etc. and different languages like English, German, Spanish, French, and Hindi etc. In the present scenario, excel addins like ‘Excel Search and Replace Tool’ have become a necessity for offices, as most offices rely heavily on computer systems for conduct of work. Paper documents have given way to soft copies to the extent that paper documents are used only if absolutely necessary. Documents are prepared mainly with the help of MS word, excel and PowerPoint giving rise to the need for addins.