Get 12 top-notch plug-ins for Excel with a 60 % discount
Ablebits.com Add-ins Collection for Microsoft Excel 2013-2003
You are trying to figure out how to merge two Excel tables. But before that you need to combine duplicate rows and delete identical information from your worksheet. Still you have to trim excess spaces that got into your sheets after importing a database. Having said this, you also need to have full names in different cells, convert kilograms into tones and replace the domain names with the new ones in your large report. You have too little time and impatient co-workers and clients.
Add-ins Collection for Excel is a multipurpose set of tools designed to simplify your daily work with data in your sheets. From merging data and removing duplicates to randomizing and replacing information in Excel, it will do it all quickly and flawlessly.
Add-ins Collection in detail
This package of nifty add-ins will open new possibilities for you in analyzing and working with data. Level up your Excel skills using these most helpful tools from the collection.
This tool will help you find duplicate or unique values. No matter whether you have your data in 1 or 2 worksheets, you can easily get rid of dupes or find unique values in 5 steps. After the data are found, you can select, color, copy, move, or delete them.
Merge Tables Wizard
This tool will combine two Excel tables. It searches your second table for updates and pastes them into your main worksheet. You can select additional options for matching and non-matching rows as well as add a status column that will mark the rows as updated, non-updated, or new.
Combine Rows Wizard
Merge duplicate rows in Excel by key column values. The add-in will place all relevant records for the values in your key column(s) to one row using the delimiter of your choice.
If your table has any formatting, characters, or spaces that obstruct data processing, you're sure to find the right tool in the Cell Cleaner add-in. It removes all unwanted characters from the infamous leading, trailing spaces and extra blanks between words, to your custom symbols. It can correct the format of all the numbers formatted as text in your worksheet, and change case in all the selected cells simultaneously. Very simple to use tool essential for your Excel routine.
Merge Cells Wizard
Merge values in cells, rows or columns preserving all data. Besides creating the structure you like, you can separate values with the selected delimiter and place the results to the specified location.
Fuzzy Duplicate Finder
When getting data from different sources, discrepancies may creep into your worksheets. Fuzzy Duplicate Finder offers flexible settings to find and correct all typos and mistakes in the table.
Advanced Find & Replace
If you need to quickly and easily find and replace some data in multiple workbooks simultaneously, this add-in is for you. Search and swap in values, hyperlinks, comments and formulas. You can select or export the found entries.
Select a range in your table and instantly fill it with random numbers, dates, Booleans, custom list values, and strings. With the help of Random Generator you can get strong passwords, codes, pick the people on duty, or create data for test tables.
If you need to randomly pick 4 employees to work on a project and want your choice to be unbiased, this program will help you. It selects the specified percentage or number of values in your table. You can also benefit from its possibility to shuffle cells, columns, and rows in you sheet.
Use this feature to get multipart names in separate cells in the selected location. It recognizes names that contain up to 5 parts and divides them into First, Middle and Last Name, Title and Suffix columns respectively.
Measurement Units Converter
Have numbers in your worksheet quickly re-calculated into another unit with the Measurement Units Converter add-in. You can choose to add results as comments or convert the selection in just one click.
Workbook Manager is a convenient Excel explorer for managing multiple Excel workbooks and sheets. You can simply drag-and-drop sheets between Excel files to move them, rename them right in the pane, and add or delete new files in just one click. This add-in brings all possible workbook management features to one pane.
Ablebits.com Add-ins Collection for Excel system requirements
- Windows 8 (32 and 64-bit)
- Windows 7 (32 and 64-bit)
- Windows Vista (32 and 64-bit)
- Windows XP (32-bit)
- Windows Server 2003, 2008, 2012
- .NET Framework must be installed.
- Microsoft Excel 2013 (32 and 64-bit)
- Microsoft Excel 2010 (32 and 64-bit)
- Microsoft Excel 2007
- Microsoft Excel 2003
Ablebits.com Collection for Excel version
Current add-in version: 2013
published on: Feb 15, 2013