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
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
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
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
The REPT function Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
Read more REPT Function