Solve 300+ daily tasks in Excel
Ablebits Ultimate Suite

Ablebits Ultimate Suite
Shared Email Templates for Outlook
Bulk but trusted emails from your Outlook mailbox
A complete collection of tools for simpler work with spreadsheet data
An Excel formula to see if two cells match is as simple as A1=B1. However, there may be different circumstances when this obvious solution won't work or produce results different from what you expected. Continue reading
To check if a given value is between two numbers, you can use the AND function with two logical tests. To return your own values when both expressions evaluate to TRUE, nest AND inside the IF function. Detailed examples follow below.
There may be various situations when you want to split cells in Excel. Now, we finally have a special function for this, TEXTSPLIT, that can separate a string into multiple cells across columns or/and rows based on the parameters that you specify.
When working with long strings, you may often want to extract a specific part of them for closer examination. In Microsoft Excel and Google Sheets, there are several ways to get text between two characters or substrings. In this article, we'll discuss the fastest and most effective ones.
Did you know that your Google Sheets can find & handle duplicates automatically? You just need one special add-on for that – Remove Duplicates.
When working with complex datasets in Excel, you may often find yourself in a situation when you need to extract data to the right of a certain character or word. This tutorial will show you the fastest way by using the span-new TEXTAFTER function.
In earlier Excel versions, extracting text before a space, comma or any other character was quite tricky. In Excel 365 and Excel for the web, we now have a brand-new TEXTBEFORE function that does the magic!