letter Validation

[Maltenrazer]

Hello, there is a problem with the Validation..

it will restrict me from entering numbers, but it allows me to ente
any letter first and then any number, symbol i wish to... please help
i want to restrict it to entering only letters. and it should not allo
me to enter numbers and symbols in between letters.


thank yo

 

[Arvi Laanemets]

Hi

I'm afraid you'll need a bit of VBA for this - p.e. you create an UDF, which
returns true, when there are only charecres in cell entry the function is
referring to. Sorry, but I have to leave soon, so there isn't enough time
for me to take a try.


Arvi Laanemets

 

[Dave Peterson]

I think this came from Harlan Grove:

=AND(MIN(CODE(MID(UPPER(A1),ROW(INDIRECT("1:"&LEN(A1))),1)))>=65,
MAX(CODE(MID(UPPER(A1),ROW(INDIRECT("1:"&LEN(A1))),1)))<=90)