## LEN 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.

Written by kazamraza
no comments

Classified in : Excel Formulas, Text Functions

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.

Written by kazamraza
no comments

Classified in : Excel Formulas, Text 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.

Written by kazamraza
no comments

Classified in : Excel Formulas, Text 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.

Written by kazamraza
no comments

Classified in : Excel Formulas, Text 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.

Written by kazamraza
no comments

Classified in : Excel Formulas, Text 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.