Data Input Validation

[Mark S]

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,

 

[Mark S]

Meant to mention that I can't use a drop down list for various reasons!

Mark S

 

[T. Valko]

You can still use the List option, just uncheck In-cell dropdown.

 

[Tyro]

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]

Brilliant! thanks

You can still use the List option, just uncheck In-cell dropdown.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Brilliant! thanks