AbleBits Ultimate Suite for Microsoft Excel 2014.4.2.357

The Ultimate Suite is an excellent set of tools for everyday use. Each add-in solves one of your usual tasks, whether it is removing duplicates or merging data, and it solves the task impeccably.

By combining several tools you can easily build a solution for practically any task just as with a Lego set. Your usual tiring, time-consuming and error-prone routines are not a challenge any longer!

Merge data

Combine two tables by common columns.
Merge several cells, rows or columns into one.
Consolidate multiple worksheets.
Join data from duplicate rows into one leaving unique data only.
Combine data from 2 Excel worksheets using Merge Tables Wizard

Dedupe worksheets

Remove duplicate rows in your table.
Check 2 worksheets for duplicates.
Find fuzzy matches (similar entries or typos).
Removing duplicates in Microsoft Excel 2013 - 2003

Find data

Find (and replace) in all open workbooks at a time, search for values, formula, hyperlinks, etc.
Find and fix broken links or references to other workbooks.
Find cells of a particular color or font.
Find all numbers or dates within a specified range.
Search in all open workbooks and worksheets with Andvanced Find & Replace

Clean and polish up data

Trim excess spaces.
Remove unwanted or non-printable characters.
Change text case.
Delete empty cells or rows.
And more…
Remove spaces in Excel, change text case, remove characters, convert text to numbers - Cell Cleaner for Excel

Randomize data

Generate random unique numbers.
Generate random strings, passwords, dates.
Shuffle rows, columns or individual cells.
Get a random sample from a set of your data (e.g. for a lottery).
Generate random numbers in Excel, create passwords with Random Generator add-in

Split data

Separate a large table into several smaller tables by selected column.
Split a table into individual card views for each record.
Spilt full names from one cell into separate cells for first name, last name, salutation and so on.
Split Table Wizard will pull your table apart in seconds

And much more

Perform math operations on all selected numbers at once.
Convert measurement units.
Fill empty cells with the values from the adjacent cells.
And have a dozen other smart tools at your fingertips.