Restricted Entry into a cell.

[chriscousins]

Hi guys.
Great Board...used it regularly for help.
This is my first question...

I need to restrict entry to a cell to any numeric value plue allow "r" "s" "h" and "a" as well (as well as the upper case of the letters)

I want to delete any entry other than those allowed, and have nearly managed it using target.value and case to select the allowed letters, but how do I allow the numbers as well as the 4 letters.

Hope you understand what I'm trying to acheive.

Help appreciated.

 

[mightymishra]

one quick thing i managed
i tried to do this validation in cell G11

In Data>Validation
under Settings tab
Allow Custom
Formula =OR(ISNUMBER(G11),CODE(LOWER(G11))=104,CODE(LOWER(G11))=114,CODE(LOWER(G11))=115)