LEN Function

« Back to Glossary Index

This Excel function returns the number of characters in a text string. The function does count spaces. It requires only 1 argument, such as the cell reference or string enclosed in quotes.

Argument	Description
Text	The cell reference or text string in quotes.

Syntax Example	What Happens
=LEN(A2)	This would count the characters in cell A2.
=LEN(“The answer to the universe is 42”)	This would count characters between quote marks.

« Back to Glossary Index