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.
Read more REPLACE Functions
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.
Read more PROPER Function
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.
Read more MID Functions
This article describes the formula syntax and usage of the LEN functions in Microsoft Excel.
Description
LEN returns the number of characters in a text string.
Read more LEN Functions
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.
Read more EXACT Function
