Ablebits add-ins

Merge

• Merge two Excel worksheets
• Combine duplicate rows by key columns
• Consolidate data from different worksheets
• Merge multiple Excel files into one
• Combine worksheets by column headers

• Merge cells, columns, and rows
• Build VLOOKUP formulas
• Compare 2 worksheets for differences
• Compare multiple worksheets

DEDUPE

• Find and remove duplicates in one table
• Compare two tables for matches and differences
• Find and delete the same text strings within selected cells

• Quick Dedupe for Excel lists
• Find fuzzy matches (similar records)
• Remove or highlight cells with the same values

Text

• Trim Spaces
• Change Case
• Add Text
• Extract Text

• Remove Characters
• Convert Text
• Split Text
• Split Names

MANAGE

• Move, find, and sort Excel worksheets
• Manage columns an easy way

• Insert watermark in Excel
• Create table of contents

DATE AND TIME

• Add or subtract different day and time units
• Pick and calculate dates

• Convert text-formatted dates to normal dates based on the specified day /month /year order

TRANSFORM

• Convert a crosstab table to list
• Easily make and print address cards in Excel
• Split worksheet into several tables by column
• Convert rows to columns and vice versa

• Swap two ranges
• Flip table vertically or horizontally
• Remove blanks in Excel
• Fill empty cells with the value of above or below cell

SEARCH

• Find and replace in all open Excel workbooks and worksheets
• Select cells by color, value, or data type
• Find and select similar cells

• Filter based on cell value
• Find broken links

CALCULATE

• Count and sum cells by background or font color
• Count characters and words in a cell

• Calculate ranges

UTILITIES

• Convert currency number to words
• Add or remove leading zeros with a mouse click
• Generate random numbers, passwords, strings, dates
• Sort and select randomly

• Insert multiple pictures at once
• Aggregate or copy same ranges
• Create, edit, and view comments

• Customizable and adaptive mail merge templates
• Personalized merge fields depending on the recipient or context
• Dynamic attachments and images

• Mailing lists based on Excel tables
• "Send immediately" and "send later" scheduling

• Trim extra spaces
• Convert text to numbers
• Count characters and words
• Change letter case
• Extract text or numbers
• Remove text by its position
• Add the same text to selected cells
• Split cells by symbol, string, or mask

• Replace unwanted characters
• Eliminate leading zeros
• Clean non-printing characters
• Swap text in your cells
• Find, extract, replace, and remove strings by means of regexes
• Merge columns, rows, or cells into one
• Combine rows by duplicates