Upper case only, in data validation?

Hello,

I want to limit the characters that can be entered into a cell.

Only the following characters are allowed:
- A B C D E F G H J K

I created a list and used data validation, but the system allows lower case letters to be entered.

How can I set the data validation so only the characters shown above are allowed, all caps, but also including the "-" character?

I'm using Excel 2000.

Thanks for helping me.

Hello,

you could use a custom data validation formula

=NOT(ISERROR(FIND($A$1,"-ABCDEFGHJK")))

cheers