Multi-Level Header Support for Designer Applications

This tutorial shows how to create multi-level columns in designer applications, effectively ‘categorizing’ columns into multiple levels. A typical example is a monthly data table grouped into quarterly sections. We’re going to be using a monthly...
Function: MID

Function: MID

The MID function returns a sub-string from a string, starting from a specified location. In this guide, we’re going to show you how to use the Excel MID function and also go over some tips and error handling methods. Supported versions All Excel versions Excel MID...
Function: RIGHT

Function: RIGHT

The RIGHT function returns a sub-string from a specified string, starting from the right-most character. In this guide, we’re going to show you how to use the Excel RIGHT function and also go over some tips and error handling methods. Supported versions All Excel...
Function: LEFT

Function: LEFT

The LEFT function returns a sub-string from a specified string, starting from the left-most character. In this guide, we’re going to show you how to use the Excel LEFT function and also go over some tips and error handling methods. Supported versions All Excel...
How to delete all comments in Excel using VBA

How to delete all comments in Excel using VBA

Excel, just like other Office products, supports comments. Although comments are helpful to add tips or other details into your spreadsheets, deleting them may become time consuming while trying to find and select all of them. In this article, we’re going to...
Function: DATEVALUE

Function: DATEVALUE

Excel DATEVALUE function returns a date serial number from a specified date that is stored as text. This function comes in handy when your dates are stored as text data, instead of Excel’s date number format. In this guide, we’re going to show you how to use the...
Function: DATE

Function: DATE

The DATE function in Excel returns a date serial number from specified year, month and day values. In this guide, we’re going to show you how to use the DATE function and also throw in some tips and error handling methods. Supported versions All Excel versions Date...