| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation Rule anomaly
I have the following custom validation rule that checks for, and disallows,
the inputting of a space or CHAR(160): =AND(ISERROR(FIND(" ",A2))=TRUE,ISERROR(FIND(CHAR(160),A2))=TRUE) However, if someone pastes some text containing a space, the validation rule doesn't trap it! Can anyone tell me why this occurs, and a possible fix to my validation rule? Thanks, Bob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Validation Rule anomaly
try:
=AND(NOT(ISNUMBER(FIND(" ",A2))),NOT(ISNUMBER(FIND(CHAR(160),A2)))) HTH "Bob" wrote: I have the following custom validation rule that checks for, and disallows, the inputting of a space or CHAR(160): =AND(ISERROR(FIND(" ",A2))=TRUE,ISERROR(FIND(CHAR(160),A2))=TRUE) However, if someone pastes some text containing a space, the validation rule doesn't trap it! Can anyone tell me why this occurs, and a possible fix to my validation rule? Thanks, Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying formulas using a Validation rule | Excel Worksheet Functions | |||
| validation rule - force text entries to appear as Proper | Excel Worksheet Functions | |||
| Validation rule - custom 5 digits w/ leading zeroes | Excel Worksheet Functions | |||
| Validation rule | Excel Discussion (Misc queries) | |||
| validation rule | Excel Worksheet Functions | |||
Hybrid Mode
