The PROPER Function
It capitalizes the first letter of each word and converts the rest of the letters to lowercase.
1904, 2019
Monthly Archives: April 2019
1904, 2019
The MID Function
It returns a specific amount of characters from a string, starting at a specific position in the string.
1904, 2019
The LOWER Function
It converts all letters in a string to lowercase.
1904, 2019
The LEFT Function
It returns a certain amount of characters from the beginning of a string.
1904, 2019
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
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.
