Ablebits blog

Posts tagged "Video"

Feb

How to change case in Google Sheets: UPPER, lower, Capitalize Each Word, Sentence case, tOGGLE

Changing text case in Google Sheets may seem an intricate task as there is no such option in the standard menu. Even so, the task is very much resolvable. In this blog post, I share different ways to capitalize your words or turn them into lowercase, uppercase, and sentence case. Continue reading →

May

How to combine duplicate rows, merge values, and add subtotals in Google Sheets

Whether or not you're new to Google Sheets add-ons, you’ll love the news: now it takes three simple steps to combine duplicate rows and keep all unique information safe. Continue reading →

Feb

Video: Conditional formatting based on another cell

Learn how to quickly highlight entire rows based on another cell value in Excel. Continue reading →

Products
Windows
Ultimate Suite for Excel Shared Email Templates for Outlook Mail Merge for Outlook Link Checker for Word
Mac Os
Text Toolkit for Excel Shared Email Templates for Outlook Mail Merge for Outlook
Outlook Online
Shared Email Templates for Outlook Mail Merge for Outlook
Google Workspace
Add-ons for Google Sheets Add-ons for Google Docs
Ultimate Suite
70+ professional tools for Microsoft Excel

This comprehensive set of time-saving tools covers over 300 use cases to help you accomplish any task impeccably without errors or delays.

Merge multiple worksheets

Compare sheets for differences

Remove duplicates

Merge cells in Excel

Calculate dates and times

Combine sheets by column headers

Trim extra spaces

Count characters and words

Convert text to number

See all tools

Works for: Windows
Read more about Ultimate Suite Try 14 days for free
Shared Email Templates
Reply to routine emails faster than ever

Do not waste your time on composing repetitive emails from scratch in a tedious keystroke-by-keystroke way. Type your response just once, save it as a template and reuse whenever you want.

Quick replies for routine emails

Fully customizable templates

Gorgeous html-based designs

Dynamic templates with fillable fields

Comfortable template sharing

Custom-tailored bulk mailings

Company and team-wide signatures

Easy user and team management

Works for: Windows•macOS•Outlook Online
Read more about Shared Email Templates
Link Checker for Microsoft Word
Manage links in your document with ease

Find all links in your document, get them verified, correct invalid ones and remove unnecessary entries with a click to keep your document neat and up to date.

Search for all link types

Define link states

Edit multiple hyperlinks at a time

Sort and filter links by different criteria

Works for: Windows
Read more about Link Checker
Text Toolkit for Excel
35+ handy options to make your text cells perfect

Instead of building formulas or performing intricate multi-step operations, start the add-in and have any text manipulation accomplished with a mouse click.

Trim extra spaces

Convert text to numbers

Count characters and words

Change letter case

Extract text or numbers

Remove text by its position

Split cells by symbol, string, or mask

Replace unwanted characters

Eliminate leading zeros

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

Works for: macOS•Excel Online
Read more about Text Toolkit
30+ tools to boost your Google Sheets
This smart package will ease many routine operations and solve complex tedious tasks in your spreadsheets.
Read more about Power Tools Try it for free

Add-ons for Google Sheets

Merge Sheets Function by Color Remove Duplicates Compare Sheets Combine Sheets Table Styles Advanced Find and Replace See all products

Add-ons for Google Docs

Search & Navigate Doc Tools Styles for Google Docs
Mail Merge
Ideal for newsletters, proposals, and greetings addressed to your personal contacts

Mail Merge is a time-saving approach to organizing your personal email events. It offers:

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

Works for: Windows•macOS•Outlook Online
Read more about Mail Merge
Downloads
- Current versions
- Archived versions
Documentation
Support
Blog
About us
Purchase