## How to use the LEN function

*Article updated on January 26, 2018*

The LEN function returns the number of characters in a cell value.

Formula in cell D3:

Cell B7 contains a single space character, the LEN function accurately returns 1.

### Excel Function Syntax

LEN(*text*)

### Arguments

text |
Required. The text string or cell reference you want to count the number of characters in. |

### Comments

The LEN function does not count the number of characters in a formula, however, it counts the number of characters a formula displays.