Excel FunctionsLesson 91Free preview

LEN

This lesson is part of Excel · All levels

Summary

LEN is an Excel text function that calculates the number of characters in a text, including spaces. The syntax is. This function is often used for validating input length, such as an identity number or password.

Key points

Syntax: LEN(text) returns the number of characters
Space counts as a character
The empty cell gives a result of 0.
Combined with LEFT, RIGHT, MID, and SUBSTITUTE for text manipulation

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.