Excel LEN function
Description
The LEN function returns the number of characters in a text string.
Syntax and arguments
Formula syntax
| LEN(text) |
Arguments
|
Return Value
The LEN function returns the number of characters.
Remarks
1. Number formatting is not included to count. For example, A1 is date 4/26/2010, LEN(A1) returns 5, as the actual value in A1 is 40294 which just be formatted as date 4/26/2010.
2. The spaces are included to count.
Usage and Examples
Example 1 Count characters of a number
| String | Count | Formula | Description |
| 4534 | 4 | =LEN(C3) | Length of 4534 |
| 123.11 | 6 | =LEN(C4) | Length of 123.11 |
| 23.00 | 2 | =LEN(C5) | Length of 23(formatted as 23.00) |
| 19-Aug-13 | 4 | =LEN(C6) | Length of 4980(formatted as date) |
Example 2 Count characters of a text string
| String | Count | Formula | Description |
| Apple | 5 | =LEN(C7) | Length of Apple |
| Water Melon | 11 | =LEN(C8) | Length of Water Melon |
Download sample
Relative Functions:
-
Excel DOLLAR Function
The CHAR function is used to convert a number to text in the currency formatting, with the decimals rounded to the given number of decimal places.
-
Excel FIND Function
The FIND function is used to find a string within another string, and returns the starting position of the string inside another one.
-
Excel LEFT Function
The LEFT function extracts the given number of characters from the left side of a supplied string .
-
Excel CONCAT Function
The CONCAT function joins texts from multiple columns, rows or ranges together.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
