The SEARCH Function
It finds one text string that exists inside another text string and returns the position within the second string, from which the first one begins. It is NOT case-sensitive and allows wildcard characters.
1904, 2019
Category Archives: Functions
1904, 2019
The FIND Function
It finds one text string that exists inside another text string and returns the position within the second string, from which the first one begins. It is case-sensitive and doesn’t allow wildcard characters.
1904, 2019
The EXACT Function
It compares 2 strings and returns TRUE if they are exactly the same. It is case-sensitive.
1904, 2019
The CONCAT Function
It is used to join two or more text strings into one string. This function has replaced the CONCATENATE function.
1904, 2019
The CONCATENATE Function
It is used to join two or more text strings into one string. This function has been replaced by the CONCAT function. Even though it is still available you should avoid using it because it may not be available in future versions of Excel.
1904, 2019
The CHAR Function
It returns the character specified by a number from the computer’s character set.
1904, 2019
The LEN Function
It returns the number of characters in a text string.
1904, 2019
The PI Function
It returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.
1904, 2019
The MROUND Function
It rounds a number to a specific multiple.
1904, 2019
The ROUNDDOWN Function
It rounds a number down to a specified number of digits.
