Excel Search and Replace

Excel Search and Replace

$49.95

Excel Search and Replace tool can easily find and replace words from bulk of Excel files. The software consists of latest & unique components that help in finishing the work in the shortest span of time.

Product Description

It can process all formats of Excel like .xls, .xlsx, .xlsm, etc. in bulk. Users can dump as much files as they can to change words from them. The tool is capable of finishing the task accurately in the shortest span of time.

Along with changing of words this find and replace can also do numerous types of formatting. You can change fonts, their size & even color with the given choices. Users can also make a list of those words that they have kept & replaced. The words can be saved for future use either in Excel or in Text format. The software also provides you choice to save the files with changed words in a target folder of your choice. Thus the work of this software is not just changing words but can also save them for you.

This amazing tool can work in all variants of MS Excel i.e. 2013, 2010 & 2007 without any difficulty. You can install & run it in any of them. These things place this software on the top in the list of best find and replace words tool.

  • The tool can find and replace words from multiple Excel files.
  • It can execute all Excel formats like .xls, .xlsx, .xlsm,
  • You can drop as much files as you want to replace words from them.
  • Users can save the words both kept & replaced in excel or in text format.
  • If user already has a list of words he can utilize by dumping in the tool.
  • The files with changed words can be saved in a target folder assigned by user.
  • It can run in all variants of MS Excel i.e. 2013, 2010 & 2007.

Q.1. How to Register, Buy and Activate the software?

Registration window will be display in the un-registered version every time.
Register: To register the “Excel Search and Replace” click on the “Enter Activation Key” Button and fill the Registration Detail with the Activation Code.

Buy : You have to Buy “Excel Search and 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 and Replace” by clicking on “Continue in Demo Version” Button.

registration

registration

Q.2. How to Add Multiple Excel Files?

We made this version more user friendly with its new stepwise process. It has Three steps:

  • Step 1 : Add Files (XLS, XLSX, XLSM, XLT).
  • Step 2 : Add or Load Words (CSV/TXT).
  • Step 3 : Format Words & Final Process.

Step 1 : Add Files – In this step you can add MS Excel (.xls, .xlsx, .xlsm, .xlt) files, just click on “Add Files” button to open file dialog box select files you want to add, you can select multiple files. You can also add all files of a selected folder by clicking on “Add Folder” button, it automatically search the selected folder and add all the MS Excel Files.

Remove Selected : You can remove the selected files from the file list, to select multiple files in file list use Ctrl or Shift key. You can also remove files by pressing DEL key from Keyboard.

Clear File List : You can remove all files from the file list, it will alert you before removing all files. You can also remove files by pressing DEL key from Keyboard.

Add Words : Press “Add Words” button to go to next Step

Excel Search and Replace

Q.3. How to Add Words to the Find and Replace List?

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.

Excel Search and Replace

Q.4. How to Format Word in the Find What and Replace With List?

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.

First Bar Excel Search and Replace
Second Bar
Third Bar
Fourth Bar
  • First bar shows the Text, you can change the text, just type in textbox and press Update Text button to modify the Text.
  • Second Bar shows the Find Options like Match Case, Match entire cell content, you can change them at this point.
  • Third Bar Shows the formatting tools like Bold, Italic, Underline, strike through, Backcolor and Forecolor.
  • Fourth Bar shows the Font Name & Font Size. If you apply formatting on Find List it will search in the formatted text in doc files. If you apply formatting on Replace With List it will format the replaced word.

Remove Selected : Remove all selected words from the List.
Clear File List : Remove all words from the List and Empty the Word List.
Clear Formatting : Clear all applied formatting from the list.
Start: To open the “File Folder Options”.
Open Target Folder: To open Separate Folder which will be selected to save the processed files.
Show Log File: To open log File .

Excel Search and Replace

Q.5. How to use File Folder Options?

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.

Excel Search and Replace
Excel Search and Replace

Q.6. Log File

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.

Excel Search and Replace

Q.7. How to Deactivate Software to transfer to other PC?

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.

Excel Search and Replace

Excel Search and Replace

Excel Search and Replace

Reviews

There are no reviews yet.

Be the first to review “Excel Search and Replace”