Download AbleBits Ultimate Suite for Microsoft Excel v2016.4.510.1344-P2P
ÃÂ Comprehensive set of time-saving tools. With this collection of 40+ professional tools, you can accomplish any task impeccably without errors or delays. ItÃ¢ÂÂs 15 years of experience with Office development embodied in the perfect code of solutions that work flawlessly on all Excel versions and all datasets.
* Ablebits Data tab Ã¢ÂÂ professional tools for data management
* Ablebits Utilities tab contains tools that simplify daily tasks
* Ablebits Quick Tools tab is full of useful one-click utilities
* 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.
* Remove duplicate rows in your table.
* Check 2 worksheets for duplicates.
* Find fuzzy matches (similar entries or typos).
* 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.
* Trim excess spaces.
* Remove unwanted or non-printable characters.
* Change text case.
* Delete empty cells or rows.
* 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).
* 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.