If you spend any amount of time studying and manipulating data in Microsoft Excel, you know there’s things you want to do that you simply can’t. Identifying trailing spaces for example, that screw up your sorting. Or converting numbers from text into actual numeric form (i.e. “one” to 1.). Or selecting similar values in adjacent cells.
Enter ASAP Utilities, a handy little Microsoft Excel add on that does all that and more. From their website:
About ASAP Utilities
ASAP Utilities is a powerful Excel software add-in that fills the gaps in Excel, and automates frequently used tasks. Since 1999 it has grown to become probably one of the world’s most popular add-ins for MS Excel.
Time saving – speed up your work in Excel
ASAP Utilities is the product of many time-saving features and additions for Excel.
The extensive features are the result of years of experience and development, combined with the feedback from many respected users at different levels of experience. Particularly the feedback from users has been very important, and will continue to be important in further development.
ASAP = As Soon As Possible
ASAP Utilities is called this way because it significantly reduces time-consuming work. ASAP is an acronym stat stands for “As Soon As Possible”. Some choose to spell it out, others tend to pronounce it “aysap”. The word utilities means something useful. Combined together ASAP Utilities stands for useful time-saving macro tools for Excel.
Most people struggle with managers, bosses or clients that tend to ask for you to get the job done yesterday, which of course is often difficult to pull off. ASAP Utilities doesn’t allow you to travel back in time but it can certainly help you to speed up your work in Excel.
Here’s a screen shot of some of my favorite functions. They’re great for creating affiliate datafeeds quickly and easily, and tidying up some mat or text.