Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
This article describes the formula syntax and usage of the LEN functions in Microsoft Excel.
LEN returns the number of characters in a text string.
The EXACT function is used to Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.
This function is used to join two or more text strings into one string.