allowable no of character
Here you go
=IF(LEN(A1)=11,"It's 11 characters long","False")
Sandy
ShamsulZ wrote:
friends, i'm looking for a formula that can only detect certain no of
letter/digit say a cont no will have only 11 digit&letter (ABCD1234567). as
there is long list some of the data is not 11 digit. i want to get a formula
that will show 'false' if it is not 11 digit/letters. Thanks a lot friend
|