Here are some key features of “AbleBits Ultimate Suite for Excel”:
– 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