Function: LARGE

Function: LARGE

The Excel LARGE function is a Statistical formula that returns largest value in an array or a range. In this guide, we’re going to show you how to use LARGE function and also go over some tips and error handling methods.Supported versionsAll Excel versionsExcel LARGE...
Function: SMALL

Function: SMALL

The Excel SMALL function is a Statistical formula that returns the smallest value in an array or a range. In this guide, we’re going to show you how to use the Excel SMALL function and also go over some tips and error handling methods. Supported versionsAll Excel...
Function: CLEAN

Function: CLEAN

The Excel CLEAN function is a Text formula that removes “non-printable” characters from a text string. The function is especially useful for eliminating unsupported characters from a text that was imported from an external source. In this guide, we’re...
Function: TRIM

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

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 versionsExcel...
How to customize AutoCorrect

How to customize AutoCorrect

The AutoCorrect is an essential feature which is designed to correct typos automatically. This feature is also helpful for changing abbreviations to full versions, adding symbols, or correcting grammar errors, but it can also sometimes do things in a way that...
Function: CODE

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 value in other...