## LEN Functions

Written by kazamraza
no comments

Classified in : Excel Formulas, Text Functions

This article describes the formula syntax and usage of the **LEN** functions in Microsoft Excel.

## Description

LEN returns the number of characters in a text string.

## Syntax

```
LEN(text)
text is cell reference.
```

The xxx function syntax has the following arguments:

**Text** Required. The text whose length you want to find. Spaces count as characters.

Example: National identity card length in Pakistan is 15 with dashes, We can check it using LEN function.

◢ | A | B | C | D | E |
---|---|---|---|---|---|

1 | Data |
Formula |
Result |
Check CNIC Length |
Result |

2 | 35202-1402388-6 | =LEN(A2) | 15 | =IF(C2=15,"Valid CNIC","Wrong CNIC") | Valid CNIC |

3 | 35202-046691-0 | =LEN(A3) | 14 | =IF(C3=15,"Valid CNIC","Wrong CNIC") | Wrong CNIC |

4 | 35202-8162523-6 | =LEN(A4) | 15 | =IF(C4=15,"Valid CNIC","Wrong CNIC") | Valid CNIC |