Pages

Sunday, December 16, 2018

Check if length of a number in a column is correct or not in Excel

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.

Aadhar Length
11111 =LEN(A1)=5
223 =LEN(A2)=5
567 =LEN(A3)=5
1111111 =LEN(A4)=5


No comments:

Post a Comment