| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding more then the allowable 30! | Excel Worksheet Functions | |||
| # of allowable characters in Excel 2003 cell | Excel Discussion (Misc queries) | |||
| VLOOKUP - Allowable Number Sequence | Excel Worksheet Functions | |||
| importing undelimited text file data, character-by-character | Excel Programming | |||
| what is the correct syntax for an allowable circular reference? | Excel Discussion (Misc queries) | |||
Linear Mode
