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 |
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) |