AbleBits Ultimate Suite for Microsoft Excel v2016.4.510.1344-P2P

[related_posts_by_tax posts_per_page="3" taxonomies="category" order="RAND" public_only="true" title=""]

Release Name: AbleBits.Ultimate.Suite.for.Microsoft.Excel.v2016.4.510.1344-P2P
Size: 24.56 MB
Links: Homepage – ~~NFO~~ – NTi

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.