| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation - Precede with LR and between 6 and 9 characters long.
Hi,
I currently have a validation rule running whereby it will only allow a code that starts with LR and is 6 character long i.e. LR8976 I need it to allow for either 6 or 9, or allow for between 6 and 9. Preferably one or the other as it leaves less room for error. Can you help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove characters in a cell that precede a specific hyphen | Excel Discussion (Misc queries) | |||
| Data Validation and a Long List. An Easier Way? | Excel Discussion (Misc queries) | |||
| Formula too Long for List Validation | Excel Discussion (Misc queries) | |||
| Format single column cells to be 6 characters long | Excel Worksheet Functions | |||
| last digit in string gets changed to 0 (16 characters long) | Excel Discussion (Misc queries) | |||
Threaded Mode
