LEN Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

LEN is an Excel Text function. Counts how many characters are in a text string.

LEN syntax

=LEN(text)

LEN is used to clean up and reshape text data pulled from other systems before reporting on it.

Open the live Excel-style spreadsheet and try LEN yourself. No Excel install or sign-up needed to start.

What does the LEN function do in Excel?

Counts how many characters are in a text string.

What is the syntax of LEN in Excel?

The syntax is =LEN(text). text: The text to work with.

Where can I practice LEN online for free?

Open the free live spreadsheet on Cellgrids and try LEN yourself. No Excel install is needed and you can start without signing up.