| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Input Validation
I am trying to limit user input to a range of cells to one of 15 single
letters or blank only. I can get the data validation tool to limit to a single text character, but i can not seem to get it to limit it to the 15 "approved" text letters. Can any one give me any ideas (Excel 2007) ? Many Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Input Validation
Meant to mention that I can't use a drop down list for various reasons!
Mark S "Mark S" wrote: I am trying to limit user input to a range of cells to one of 15 single letters or blank only. I can get the data validation tool to limit to a single text character, but i can not seem to get it to limit it to the 15 "approved" text letters. Can any one give me any ideas (Excel 2007) ? Many Thanks, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Input Validation
You can still use the List option, just uncheck In-cell dropdown.
-- Biff Microsoft Excel MVP "Mark S" wrote in message ... Meant to mention that I can't use a drop down list for various reasons! Mark S "Mark S" wrote: I am trying to limit user input to a range of cells to one of 15 single letters or blank only. I can get the data validation tool to limit to a single text character, but i can not seem to get it to limit it to the 15 "approved" text letters. Can any one give me any ideas (Excel 2007) ? Many Thanks, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Input Validation
If input cell is A1 and your allowable characters are "abcxyz" and blank
then: =IF(LEN(A1)<=1,SEARCH(A1,"abcxyz")) which is case insensitive If you want it to be case sensitive, use =IF(LEN(A1)<=1,FIND(A1,"abcxyz")) Tyro "Mark S" <Mark wrote in message ... I am trying to limit user input to a range of cells to one of 15 single letters or blank only. I can get the data validation tool to limit to a single text character, but i can not seem to get it to limit it to the 15 "approved" text letters. Can any one give me any ideas (Excel 2007) ? Many Thanks, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Input Validation
Brilliant! thanks
"T. Valko" wrote: You can still use the List option, just uncheck In-cell dropdown. -- Biff Microsoft Excel MVP "Mark S" wrote in message ... Meant to mention that I can't use a drop down list for various reasons! Mark S "Mark S" wrote: I am trying to limit user input to a range of cells to one of 15 single letters or blank only. I can get the data validation tool to limit to a single text character, but i can not seem to get it to limit it to the 15 "approved" text letters. Can any one give me any ideas (Excel 2007) ? Many Thanks, |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Input Validation
You're welcome!
-- Biff Microsoft Excel MVP "Mark S" wrote in message ... Brilliant! thanks "T. Valko" wrote: You can still use the List option, just uncheck In-cell dropdown. -- Biff Microsoft Excel MVP "Mark S" wrote in message ... Meant to mention that I can't use a drop down list for various reasons! Mark S "Mark S" wrote: I am trying to limit user input to a range of cells to one of 15 single letters or blank only. I can get the data validation tool to limit to a single text character, but i can not seem to get it to limit it to the 15 "approved" text letters. Can any one give me any ideas (Excel 2007) ? Many Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - input message | Excel Discussion (Misc queries) | |||
| Data Validation Input Message | Excel Discussion (Misc queries) | |||
| Data Validation-Input Mask | Excel Discussion (Misc queries) | |||
| Data Validation Input Message | Excel Worksheet Functions | |||
| DataValidationInput message | Excel Worksheet Functions | |||
![Mark S[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
