How to filter by using a formula in Excel

Filtering data helps focusing on certain aspects of a data set. Excel has built-in features for this, an Excel formula for filtering data was not in the software's scope until the introduction of dynamic array functions. In this guide, we’re going to show...

Function: TRIM

The Excel TRIM function is a Text formula which can remove the leading and trailing sections of a text string, and replace extra spaces between words with one. As the name suggests, the formula essentially "trims" the extra spaces in the target string, and...

Function: LEN

The Excel LEN function is a Text formula that returns the number of characters in a given string. In this guide, we’re going to show you how to use the Excel LEN function and also go over some tips and error handling methods. Supported versionsAll Excel...

How to generate random numbers in Excel

How to generate random numbers in ExcelYou can generate decimals between 0 and 1, and integers between certain limits using the RAND and RANDBETWEEN functions. RANDARRAY function is a new addition to randomization formulas, which is currently only...

Function: CODE

The Excel CODE function is a Text formula that converts a specified character into the corresponding code based on the character set used by your computer. This can be useful for when you want to find out the code for a specific character, or using this...

Function: CHAR

The Excel CHAR formula is a Text function that returns a character, based on the character set used by your computer. In this guide, we’re going to show you how to use the Excel CHAR function and also go over some tips and error handling methods. Supported...

Function: IFNA

The IFNA Excel formula is a Logical function that checks whether the reference contains an #N/A (not applicable) error. If the value is an #N/A error, the function returns a specified value; otherwise returns the value itself. In this guide, we’re going to...

Function: ISNA

ISNA Excel function is an Information formula that checks whether the specified value is an #N/A (not applicable) error. The function returns a Boolean value - TRUE if there is an #N/A error, and FALSE if not. In this guide, we’re going to show you how to...

Function: ISFORMULA

The ISFORMULA is a Lookup & Reference function that checks whether the specified reference contains a formula. The function returns a Boolean value based on the outcome - TRUE if there is a formula, and FALSE if not. In this guide, we’re going to show...