AbleBits Ultimate Suite for Excel is a comprehensive set of over 60 professional tools covering over 300 use cases: joining tables and joining worksheets, finding and removing duplicates, joining and splitting strings, trimming spaces and cleaning data, comparing two worksheets for matches and differences, create custom formulas, and more. Whatever task you face, you will find the tool to complete it quickly and flawlessly.
Main features of the program:
• Merge data from multiple sources
– Merge 2 sheets by matching data
– Update cells by matching data from a lookup table
– Consolidate data from multiple books and sheets
– Copy data from multiple sheets
– Copy multiple books into one: all sheets of a book into one sheet
– Layout of sheets with the same name
– Merge multiple workbooks into one
– Merge data from duplicate rows
– Merge multiple columns
– Merge multiple rows
– Merge multiple cells without losing data
• Work on duplicates
– Find and remove duplicates in one table
– Merging data from duplicate rows into one
– Comparing two sheets for duplication
– Finding and processing duplicates and their first occurrences
– Finding unique values in a table
– Finding similar records (fuzzy duplicates)
• Finding and highlighting cells
– Sum cells by color
– Counting the number cells by color
– Multi-criteria filter based on selected cells
– Highlight cells based on numeric value (max, min, between…)
– Search for cells, objects, comments, formulas, and conditional formatting
– Random selection from data
– Copy cell or range address cells to clipboard
• Search and replace data in cells
– Search and replace in all or individual books and sheets
– Search and replace in hyperlinks
– Remove or replace line breaks
– Find and fix broken links between books
– Remove extra spaces: leading, trailing, extra spaces between words
– Remove characters from cells by type: non-printable, numeric, symbols
– Case change
– Filling empty cells with neighboring values
- Replacing formulas with results, switching between absolute and relative references
– Converting numbers saved in text format
– A simple calculator using selected cells
– Converting units of measurement
• Random value generation
– Generating Unique Random Numbers
– Generate passwords and other random strings
– Generate a random string from a template
– Randomly populate cells with values from predefined lists
– Generate unique random dates
– Populate a range with random numbers
• Table processing and transformations
– UNPIVOT Table: crosstab to flat style
conversion – String transformations tables into labels or cards
– Splitting columns with full names into components
– Deleting empty rows
– Deleting empty columns
– Shuffling cells
• Managing books and worksheets –
Easier navigation through large Excel books
– Copying or moving sheets with the mouse
– Remove blank sheets from a workbook
– Sort Excel sheets from A to Z and vice versa
– Synchronize the selection area when switching to another sheet
• Manage comments
– Insert pictures in comments
– Customize the comment form
– View, create and edit all comments in one place
– Search and replace in comments
System requirements:
• Excel 2021/2020/2019/2016/2013/2010
• Excel included in Microsoft 365 (formerly Office 365)
• Windows 11, Windows 10, Windows 8/ 8.1, Windows 7 Download Ablebits Ultimate Suite for Excel Business Edition add-on 2022.3.3335.1054 (35.1 MB):
