Get 12 top-notch plug-ins for Excel with a 60 % discount

Ablebits.com Add-ins Collection for Microsoft Excel 2013-2003

Task

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.

Solution

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.
12 Add-ins Collection for Microsoft Excel 2013-2003.

Add-ins Collection in detail

Find duplicates in Excel: delete, mark, copy, or move them.
Combine data from two tables in 5 easy steps.
Duplicate rows easily merged into one Excel record.
Merge cells in Excel by row, column or all into one keeping all data.
Find partial duplicates, typos, misspelled words and omitted symbols in Excel.
Find and replace values in all opened workbooks and worksheets.
Generating random numbers, passwords, custom lists in Excel.
Shuffle cells, rows, columns or values in the selected range.
Split multipart names into separate cells.
Convert measurement units in Excel easily and quickly.
Workbook Manager for Excel.

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.

Duplicate Remover

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.

More about Duplicate Remover

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.

More about Merge Tables Wizard

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.

More about Combine Rows Wizard

Cell Cleaner

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.

More about Cell Cleaner

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.

More about Merge Cells Wizard

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.

More about Fuzzy Duplicate Finder

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.

Advanced Find & Replace

Random generator

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.

More about Random Generator

Random Sorter

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.

More about Random Sorter

Split Names

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.

More about Split Names

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.

More about Measurement Units Converter

Workbook Manager

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.

More about Workbook Manager


$ 119.8
Buy now

Ablebits.com Add-ins Collection for Excel system requirements

Operating System

  • 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

  • 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

Order Ablebits.com Collection for Excel

$ 119.8
Buy now
 
Contact us