Suppose there is a column having Aadhar Number which correct length is 5 .
Now excel have two column Pan Number and value will be false if length will be not equal to 5.
If Excel column name is A then put =LEN(A1)=5 for correct value result will be True else it will be false.
Now excel have two column Pan Number and value will be false if length will be not equal to 5.
If Excel column name is A then put =LEN(A1)=5 for correct value result will be True else it will be false.
| Aadhar | Length |
| 11111 | =LEN(A1)=5 |
| 223 | =LEN(A2)=5 |
| 567 | =LEN(A3)=5 |
| 1111111 | =LEN(A4)=5 |
