Excel Find and Replace is a remarkable
Find and Replace tool for MS excel files that helps the user to carryout Find
and Replace and formatting tasks in multiple excel files in a time saving
manner. Tool allows the user to add large number of files at one go. User can
add files by clicking ‘add files’ or ‘add folders’ button. After clicking on ‘add
files’ button user has to select files to be added but by clicking on ‘add
folder’ button user can automatically add all files contained in the folder.
User also has the option to remove any or all added excel files. After adding
files user needs to add words that need to replaced (Find what) and words with
which these words need to be replaced (Replace with).
User can add words one by
one or load word list from TXT or CSV files. By loading words from TXT or CSV
files user can save considerable time. After adding words user can highlight or
format words and phrases in ‘find what’ or ‘replace with’ list or even edit
text. User can seamlessly carry out different formatting tasks like bold,
italic, underline etc. in this step. User has the option to even remove all the
selected words from the list or clear all formatting. User has the option to
save processed files in separate folder or in the source folder itself. Tool
provides backup facility so that original files don’t get overwritten. Tool
also generates log file giving details of data processed. In the
present scenario, Excel search and
replace tools like this one have become a necessity for offices, as most
offices rely heavily on MS excel to process and store data. Processing large
scale data on MS excel without the use of excel add ins becomes very cumbersome.
This has given rise to efficient Find and Replace tools for excel. Recognizing
this need we have come up with this tool. This tool assists the user not only to
find and replace in excel but also carryout
formatting tasks in multiple files at one go.
More links for reading continue
No comments:
Post a Comment