How do I use LEN in Excel?
Use LEN when you want to count text length. Enter Text in that order, then add optional arguments when needed.
Excel Function
LEN
Returns the number of characters in text.
LEN(text)Arguments
text
RequiredValue for text.
Practice Preview
Use LEN to return the number of characters in cell B2 (Name in column B).
Example Table
| # | AEmployee ID | BName | CEmail | DPayment Amount | EAmount Text |
|---|---|---|---|---|---|
| 2 | E001 | Taro Tanaka | t.tanaka@example.com | 1200 | 1200 |
| 3 | E002 | Hanako Suzuki | h.suzuki@example.com | 980 | 980 |
| 4 | E003 | Ken Sato | k.sato@example.com | 2450 | 2450 |
| 5 | E004 | Aya Takahashi | a.takahashi@example.com | 3000 | 3000 |
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=LEN(B2)Result
11
Practice This Function
LEN FAQ
Where can I practice LEN?
Use the "Start Function Practice" button to jump straight into LEN drills.
What arguments does LEN use?
The main arguments are Text. Enter them in order.