letter Validation
 

Hello, there is a problem with the Validation.. :(

it will restrict me from entering numbers, but it allows me to enter
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 allow
me to enter numbers and symbols in between letters.


thank you


--
Maltenrazer
------------------------------------------------------------------------
Maltenrazer's Profile: http://www.excelforum.com/member.php...o&userid=16130
View this thread: http://www.excelforum.com/showthread...hreadid=275829

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


"Maltenrazer" wrote in message
...

Hello, there is a problem with the Validation.. :(

it will restrict me from entering numbers, but it allows me to enter
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 allow
me to enter numbers and symbols in between letters.


thank you


--
Maltenrazer
------------------------------------------------------------------------
Maltenrazer's Profile:
http://www.excelforum.com/member.php...o&userid=16130
View this thread: http://www.excelforum.com/showthread...hreadid=275829

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)



Maltenrazer wrote:

Hello, there is a problem with the Validation.. :(

it will restrict me from entering numbers, but it allows me to enter
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 allow
me to enter numbers and symbols in between letters.

thank you

--
Maltenrazer
------------------------------------------------------------------------
Maltenrazer's Profile: http://www.excelforum.com/member.php...o&userid=16130
View this thread: http://www.excelforum.com/showthread...hreadid=275829

--

Dave Peterson