Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
letter Validation | Excel Worksheet Functions | |||
letter Validation | Excel Worksheet Functions | |||
letter Validation | Excel Worksheet Functions |