The Add-ins Collection for Microsoft Excel includes 12 add-ins that were specially designed to deal with the most tedious, painstaking and error-prone tasks in Excel that consume a lion's share of your time, energy and patience. Just try them and you will see that your efficiency in Excel will increase by 50%, at the very least.
The plug-ins included in the Collection will help you with:
Removing duplicates and finding uniques
Removing typos and misprints
Merging tables, combining data from different sources
Merging cells, rows and columns
Combining data from duplicate rows into one
Finding and replacing in all data, in all workbooks
Generating random numbers, passwords, custom lists
Shuffling and selecting random rows, columns and cells
Converting measurement units
Splitting names, titles and salutations
Navigating between workbooks and worksheets
Cleaning up cells in worksheets
The Collection works with Microsoft Excel 2010 32-bit and 64-bit, 2007, 2003.
ExcelPipe Lite (+1 Yr Maintenance) - Automatically Find and Replace across Thousands of Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate... ...