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