(To know more about this product Open Tab)
Register : To register the "Excel Search & Replace" click on the "Enter Activation Key" Button and fill the Registration Detail with the Activation Code.
Buy : You have to Buy "Excel Search & Replace" to get Activation Code. You Can Buy it From our Site by Clicking on "Buy Activation Key" button.
Try Demo: You can use demo version of "Excel Search & Replace" by clicking on "Continue in Demo Version" Button.
In this step you can add words or phrase for Find What and Replace With List Set by Set or from a Comma/Line Separated Text file. You can type word and press enter or click "Add to List" button to add the same on Word List below. To add Words from TXT file just check the Find What or Replace With radio button and click "Load List" to Add Words.
Find What: Enter word in this text box to Find. You can also find special characters like Paragraph Marks, Tab Characters, Manual Line Breaks and all special characters available in MS-EXCEL FILE which is not listed here. You can also use Wildcard Characters (*).
Replace With: Enter word in this text box to Replace. You can also replace special characters like Paragraph Marks, Tab Characters, Manual Line Breaks etc. as you do in MS-EXCEL FILE.
Find Options: Before adding word set select your desired find options.
Match Case: Check this option if you want your search to be case sensitive.
Match entire cell content: Check this option if you want your search to be cell specific.
Replace in All Sheets: Check this option if you want to search and replace in entire workbook.
Replace in First Sheet: Check this option if you want to search and replace only in first sheet of workbook.
Format Words & Final Process- In this step you can format or highlight your selected words or phrases for Find What and Replace With List or you can also Edit the Text and change the Find Options.
Click on a Word in the List to open format panel. Format Panel has four bars.
Process all Files in a Separate Folder : Check this option if you want to process all files in a single separate folder. Click on browse button to select the folder. In this option all processed files name include a counter and suffix like "1_FR_1.xls", "1_FR_2.xlsx", "2_FR_3.xls"
Process in Same Folder : Check this option if you want to process all files in their native folder.
Define Custom Suffix: You can define your own initial to processed files, if you leave blank Suffix Text box then it overwrite the original files if Native Folder option is selected means find and replace process will be done directly in the original files.
Create Log File : Check this option if you want to create a log files for analyzing your file and word process.
Overwrite : Check this option if you are reprocessing the same files. It will overwrite previous files.
Start Process : Press "Start Process" to start the Find & Replace process.
Stop Process: To Stop the Find and Replace process.
A log file created which has all files and word records, it shows in which file how many words are found & replaced and highlighted and you can also open each file by double clicking on file name direct from the log file itself. Click on Header to open File.
Go to Help Menu. Now click on Deactivate option.
Step 1 : Deactivate from current PC.
Step 2 : Install the software on new PC and Register it with same Activation Key.