## TRIM

Explanation TRIM function is used for the removal of extra space characters.  When the excess spaces appear between two words, the function keeps only one space character. Example Notice the…

## SUBSTITUTE

Explanation The SUBSTITUTE function allows us to replace a character (or a number of characters) with another character (or a number of them) within a certain text expression or cell. …

## SEARCH

Explanation SEARCH function lets us find the position of a text within another text/cell.  Note that FIND is case-insensitive. You can use it to lookup lowercase/uppercase letters - all combinations…

## FIND

Explanation FIND function lets us find the position of a text within another text/cell.  Note that FIND is case-sensitive, meaning that if you try to find "GOAT" within "goat cheese",…

## LEN

Explanation LEN function is used to discover the LENGTH of a cell - It allows us to know the number of characters in a certain cell. Let's see how it…

## CONCAT

Explanation Use CONCAT to combine a range of text cells. Compared to its predecessor CONCATENATE, CONCAT can join multiple cells by simply typing the cell range. The function is available…

## TEXTJOIN

Explanation TEXTJOIN function allows users to combine multiple cells together easily. Unlike previous Excel functions such as CONCATENATE, which require the user to repeat the delimiter (such as space) between…

## MATCH

Explanation MATCH function is a function which is used when we want to find the position of a certain value within a row or a column. The position is represented…

## INDEX

Explanation INDEX function is used to retrieve a value from a range of cells. For example - return the 6th item in the range A1:A8. It's most commonly used as…

## AND/OR

Functions Explained AND/OR functions allow the user to check if multiple criteria are met. They are extremely useful when combined with the IF function.  The AND function is used for…

End of content

No more pages to load