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 |