allowable no of character

[Guest]

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

 

[Sandy]

Here you go

=IF(LEN(A1)=11,"It's 11 characters long","False")

Sandy

 

[Guest]

Ok thanks a lot sandy. It help me a lot

Here you go

=IF(LEN(A1)=11,"It's 11 characters long","False")

Sandy

 

[Sandy]

no problem...anytime

Ok thanks a lot sandy. It help me a lot

 

[Guest]

Hi Shamzul,

try to see in Data>Validation>