## 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…

Skip to content
## Practice And Learn Excel Online For Free

##
SUBSTITUTE

##
SEARCH

##
FIND

##
LEN

##
CONCAT

##
TEXTJOIN

##
MATCH

##
INDEX

##
AND/OR

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. …

November 21, 2019

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…

November 21, 2019

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",…

November 21, 2019

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…

November 21, 2019

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…

November 21, 2019

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…

November 21, 2019

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…

November 18, 2019

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…

November 18, 2019

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…

November 12, 2019