Everyone of us, at some point and some time, has had to crunch the numbers, compared two list of data, and just generally scrub tons and tons of info. While execl is certaintly an excellent tool for analyzing data, it is not the best for scrubbing and prepping data. For that, I give you TextPad, an easy to use application which allows a user to quickly scrub data and prep it for analysis in execl. While there is about a 30 minute learning curve for understanding just how to use the application as well as figuring out just how TextPad and excel can work in tandem. Once you figure it out, you will be please you spent devoted the time to learning a new tool. 

Product Description: 

•TextPad® is designed to provide the power and functionality to satisfy the most demanding text editing requirements. It can edit files up to the limits of virtual memory, and it will work with the 32-bit and 64-bit editions of Windows® 7, Vista, XP and Server 2003 and 2008.

Benefits:

•The cursor can be constrained to the text, or can be positioned freely in the document view.

•Toolbar with fly-by usage hints, and an active status bar.

•A powerful search/replace engine using UNIX-style regular expressions, with the power of editor macros. Sets of files in a directory tree can be searched, and text can be replaced in all open documents at once.

•Incremental search toolbar for literal text.

What are People Saying:

•Reduces the amount of time I spend updating data

•Simple and easy to use when paired with the quick reference sheet

 

Download the application
Quick Reference Sheet