How to reverse a text string in Excel

How to reverse a text string in Excel

In this guide, we’re going to show you how to reverse a text string in Excel. Download Workbook Please note that as of we are writing this article, functions like TEXTJOIN and CONCAT are available for Excel 2019 and Microsoft 365 subscribers only. Syntax CONCAT...
How to open VCF format in Excel

How to open VCF format in Excel

VCF (Virtual Contact File), also known as vCard, is a file format for business cards that has been in use since 1996. A VCF is a text-based file format can store various information like the contact name, phone number, and email address. Although Excel does not have...
How to calculate median by criteria in Excel

How to calculate median by criteria in Excel

In this guide, we’re going to show you how to run calculate median by criteria in Excel. Download Workbook To calculate median based on a criteria, you need to supply a range of values to be compared against the specific criteria defined in the MEDIAN function....
How to run macro at a specified time in Excel

How to run macro at a specified time in Excel

With Application.OnTime method, you can set Excel to run some VBA at a specific time, or repeatedly at set intervals. In this guide, we're going to show you how to run macro at a specified time in Excel. Download Workbook Application.OnTime VBA’s Application.OnTime...
How to count cells by font color in Excel

How to count cells by font color in Excel

Although Excel doesn’t have a built-in feature for counting cells based on their font colors, filtering results by their font color is possible. In this guide, we’re going to show you how to count cells by font color in Excel. Download Workbook Steps Right-click...
How to count colored cells in Excel

How to count colored cells in Excel

Although Excel doesn’t have a built-in feature to count cells by their colors, filtering cells by their color is possible. In this guide, we’re going to show you how to count colored cells in Excel. Download Workbook Steps Right-click on a colored cell in the...
How to refer a range or a cell in Excel VBA

How to refer a range or a cell in Excel VBA

In this guide, we're going to show you how to refer a range or a cell in Excel VBA. VBA Basics Before diving into the code, let’s start with a cell or a range means in VBA. First, VBA is an object-based programming language, which means that the language refers each...
How to format numbers as file sizes in Excel

How to format numbers as file sizes in Excel

Excel’s number formatting doesn’t support file sizes by default. However, it allows you to program your own formatting style. In this guide, we’re going to show you how to format numbers as file sizes in Excel. Download Workbook The number formatting is one the...