How to Search and Replace Text in Excel and Word Files in Batch

If you use Excel or Word extensively and would like to perform “find and replace” operations in batch right from your desktop, you can do so with “Replace Genius”, a freeware program that allows you to find and replace text within Excel, Word, and text files. A great advantage is that it allows you to combine your desired text manipulation operations together and save them in “presets”. Not only can you keep these for later use, but you can also use them to perform operations on files in batch.

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+

Step # 1 - Download and Install Replace Genius

First of all you need to download and install “Replace Genius”. To do so open your browser and type this link: “www.rlvision.com/genius/about.asp”. Then click on the “Download” button. Allow the program to run the Setup and follow the steps to install the program.

Step # 2 - Replace files in Batch

For example, to replace text in Word files in batch, you need to first change the settings in the “Replace” tab. To do so, select it and fill in the fields of “Find” and “Replace with” with the words you want to find and replace.

Then go to “File” and select “Batch processing”. In the new window click on “Add files “and choose the files you want to use. Save the location for your files and click the “Ok” button. Now click “Start”. And that’s it! Repeat the same process for Excel files!

Step # 3 - Save your presets

An interesting feature of the program is that you can save your manipulations as presets for later use. To do so, go to “Presets” and click on “New”. Give it a name, then click on the “Replace tab”; choose your settings and click “Add”. Now you have your preset to use whenever you want!

Result: Congratulations! You’ve just learned How to Search and Replace Text in Excel and Word Files in Batch.

---

Closed Caption:

in this tutorial you will learn
how to search and replace text in Excel
'n.-word filed in batch you can do so
with replaced genius
a freeware program that allows you to
find and replace text
with a Nextel word and text files open
your browser and type this link
click the download button
then allow the program to run the setup
and follow the steps to install the
program
to replace text in Word files in batch
for example
you need to first change the settings in
the replaced tab
to do so selected and fill in the fields
a find and replace with
then go to file and select batch
processing
in new window click on Add Files and
choose the files you want to use
saved location for your files and click
the OK button
now click Start and that it
repeat the same process for Excel files
an interesting feature
other program is that you can save your
manipulations as presets for later use
to do so go to preset and click on
new given a name then click on the
replaced tab
choose your settings and click ed now
you have your preset to use whenever you
want
congratulations you've just learned how
to search and replace text
in Excel and Word files in batch this
was a how to tutorial
leave your comments below subscribe to
our channel n pressed like
thanks for watching