REPLACE Functions
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
REPLACE always counts each character, no matter what the default language setting is.
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
REPLACE always counts each character, no matter what the default language setting is.
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.