- dotTech - http://dottech.org -
[Windows] Batch replace text in Excel, Word, and text files with Replace Genius
Posted By Briley Kenney On June 12, 2013 @ 9:20 AM In Windows | 4 Comments
Sometimes you just need to replace sections of text in an existing document. Unfortunately, the ability to batch replace sections of text in documents is often only supported for simple text files. It seems silly when you think about it, especially considering how many people use Word, Excel and other related file types. Replace Genius is a freeware program (previously premium software) that allows you to swap out large strings of text in Excel, Word, and text files.
Replace Genius is a text replacement application that works specifically with Microsoft Word and Excel files, in addition to standard text files. Quite often I find myself wishing for something like this, so there’s no question about its potential usefulness. It also provides a slurry of other tools common to file replacement apps, like trimming, string replacement, renumbering, counter additions and more. If you have no clue what those tools are, have no fear and just read on!
Before we get to the meat of the review, Replace Genius is definitely suited more for power users. That’s not to say casual users won’t find it useful or appealing, but you might have a little trouble getting used to the advanced and sophisticated operations.
That being said, the user interface is fairly straightforward though it may seem cluttered at first glance there’s definitely a flow that you notice once you start using it. The most obvious use for Replace Genius is to batch replace large strings of text in large files, or even across multiple files. There are many reasons why you would need a tool like this, namely if you need to change something after the fact or make significant alterations to an existing document.
The basic file settings are displayed via a menu across the top of the window, like open, save, close, batch edit and apply. While the actual operations that the application can perform are in a tabbed form off to the left. The right hand listbox displays the existing content, and a preview of the changed content.
Using one of the operations is quite simple, you make your changes or selections and then choose “apply.” Before you apply anything Replace Genius displays a preview, as I’ve previously mentioned. This allows you to make sure the change is exactly what you want before you deface the original document, for lack of a better phrase.
Realistically, I could go on for hours about the different options that the application provides. The main point here is that the application works well, and the operations are quite efficient. Those operations include counter, renumber, zeropadding, formatting, replacing, casing, adding and deleting (strings), moving and spacing (removing or adding).
Where Replace Genius really shines, is the preset feature. If you find yourself performing an operation quite often, or performing multiple operations for that matter you can combine them together in a custom preset to use later. Furthermore, the presets can be used to batch edit multiple files at once.
One very peculiar, yet somewhat troubling issue with Replace Genius is that it will not change anything with Excel formulas. Meaning, it will change strings of content included in the file, yet leave the formula untouched. Needless to say, this can cause some anomalies in the file. Armed with this information though, I’m fairly confident you could avoid such issues as long as you’re careful with the program.
Another odd element of Replace Genius is that it only handles one column at a time in a worksheet. You also have to select the column manually, which can quickly become tedious.
All in all, Replace Genius is a very useful application. However, it is a niche program. It’s not the type of application you would rely on or use everyday; honestly, how often do you need to replace an entire string of text through a series of documents? Still, when do need the feature, Replace Genius is definitely a worthy application. Although there are a couple quirks, like the inability to replace or alter formulas in an Excel document, they can be overlooked. If you need it, get it.
Version reviewed: 4.3
Supported OS: Windows (XP, Vista, Seven)
Download size: 1.44MB
VirusTotal malware scan results: 0/47 
Is it portable? Yes
Article printed from dotTech: http://dottech.org
URL to article: http://dottech.org/111947/windows-review-replace-genius/
URLs in this post:
 Image: http://dottech.org/wp-content/uploads/2013/06/Replace-Genius-Welcome-Screen.png
 Image: http://dottech.org/wp-content/uploads/2013/06/Replace-Genius-UI.png
 Image: http://dottech.org/wp-content/uploads/2013/06/Replace-Genius-setup-counter.png
 Image: http://dottech.org/wp-content/uploads/2013/06/Replace-Genius-presets-window.png
 Image: http://dottech.org/wp-content/uploads/2013/06/Replace-Genius-spacing-tab.png
 Image: http://dottech.org/wp-content/uploads/2013/06/Replace-Genius-altering-files.png
 0/47: https://www.virustotal.com/en/file/6e8a950b3de5cdba29c4a562265a21b02b34dd6845b46c49a258b421cabf1593/analysis/
 Replace Genius homepage: http://www.rlvision.com/genius/about.asp
© 2008-2012 dotTech.org | All content is the property of its rightful owner.