LOWER
The LOWER function returns the text string that it receives as an argument after converting all its letters to their lowercase equivalents.
SUBSTITUTE
The SUBSTITUTE function replaces all occurrences of a text substring in a text with another text substring. It can also be used to replace only a specific occurrence of the searched text substring.
MID
The MID function extracts a string of characters from a string, given a starting position and a number of characters to extract.
SEARCH
The SEARCH function returns the position (counting from the left) of the first occurrence of a character or of a text string within another text string, and it can be specified from which character the search begins. This function is accent-sensitive but case-insensitive.
If you want to perform a case-sensitive (and accent-sensitive) search, you should use the FIND function.
FIND
The FIND function returns the position (counting from the left) of the first occurrence of a character or of a text string within another text string, and it can be specified from which character the search begins. This function is case sensitive and accent sensitive.
LEFT
The LEFT function extracts a number of characters from the beginning (from the left) of the text string passed as an argument.
RIGHT
The RIGHT function extracts a number of characters from the end (from the right) of the text string passed as an argument.
LEN
The LEN function returns the length (the number of characters) of a text string.
IFERROR
The IFERROR function evaluates an expression and returns the result obtained if it is not an error. Otherwise (if the evaluated expression returns an error), the function returns the result of evaluating the expression included as the second argument.
This function basically makes it possible to ensure that the result to be returned is never going to be an error (with the nuances indicated below), serving to catch and properly manage errors in the evaluation of expressions.
DATE
The DATE function returns a date in datetime format.
