| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting text entries
I have two columns in which I would like to limit the way text is input:
1) Lastname,First initial with no spaces (i.e., Smith,R) 2) One capital letter followed by five digits (i.e., D12345) I do not have any ideas for column 1. I can use the Limited Text validation feature for column 2, but that only limits the number of characters, not the type of characters input. Thank you so much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting raw score entries and possible pop up message alert? | Excel Discussion (Misc queries) | |||
| LIMITING DATA VALIDATION ENTRIES | Excel Discussion (Misc queries) | |||
| Limiting Entries in A List Box | Excel Worksheet Functions | |||
| Limiting Validation entries to 2 places after a decimal | Excel Discussion (Misc queries) | |||
| Limiting physical length of text in a text box control | Excel Discussion (Misc queries) | |||
Threaded Mode
