allowable no of character
 

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

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

allowable no of character
 

Ok thanks a lot sandy. It help me a lot

"Sandy" wrote:

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

allowable no of character
 

no problem...anytime


ShamsulZ wrote:
Ok thanks a lot sandy. It help me a lot

"Sandy" wrote:

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

allowable no of character
 

Hi Shamzul,

try to see in DataValidation


--

Regards,

Halim


"Sandy" wrote:

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