Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LIMITING DATA VALIDATION ENTRIES
I have a column that needs to be exactly 10 characters long, with some of the
characters alpha and some numeric. I can do this easily enough be selecting Data/Validation/Text/equals/10. But is there a way that I can ALSO limit the characters entered to alpha numeric, but without allowing "funky" characters such as those on the top row of the keyboard: !@#$%^&*()_+? Thanks for ideas! -- William |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Data Validation and limiting characters | Excel Worksheet Functions | |||
Limiting Entries in A List Box | Excel Worksheet Functions | |||
Limiting Validation entries to 2 places after a decimal | Excel Discussion (Misc queries) | |||
Data Validation for Weekday entries only | Excel Worksheet Functions | |||
Using Data Validation - how do I allow other entries | New Users to Excel |