Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking a Cells contents
How about:
=IF(AND(LEN(A1)=9,ISNUMBER(-REPLACE(A1,3,1,"")),CODE(UPPER(MID(A1,3,1)))64, CODE(UPPER(MID(A1,3,1)<96))),"Valid Order","not Valid") (all one cell) antinoz wrote: I'm trying to validate data in a column of cells to check that the format is "NNANNNNNN" (N= number A= Alpha I have) all the cell contents are different but have 9 characters containing the alphanumeric format as shown I want to put it in an If statement: so if cell A1 = mask "NNANNNNNNN" cell A2 = "Valid order" -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking the length of cell contents | Excel Discussion (Misc queries) | |||
checking a Cells contents | Excel Programming | |||
Auto-checking a checkbox based on cell contents. | Excel Programming | |||
Checking contents | Excel Programming | |||
Checking contents | Excel Programming |