LEN() Formula in Excel to count the Number of Characters in a String

The function LEN() counts and returns the length or number of characters that string or word contains. It counts characters, numbers, and special characters  also. 

Syntax:

• Start typing the function as "=LEN"
• Next enter the text with "" and press enter

Here is the simple example illustrating the use o LEN() function:

And, the answer is 16 as it contains the characters of 15 texts and 3 spaces.

You may also use it by giving the cell reference/address instead of text as follow":

And, the result is:

You may find and learn more Excel Formulas here:

(1) Top 10 Basic Excel Formulas and Functions with Examples

(2) MS Excel VLOOKUP Formula with Examples

(3) How to Calculate Average Percentage with Formula and Examples

(4) Excel HLOOKUP Function, Syntax and Formulas with Examples

(5) Microsoft Excel XLOOKUP Function and Formula with Examples