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,

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,

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,

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,

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,

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,