G Guest Jan 16, 2004 #1 is there a fomula i can use that would make a cell case sensitive and would only allow a certain number of characters please help
is there a fomula i can use that would make a cell case sensitive and would only allow a certain number of characters please help
P Peo Sjoblom Jan 16, 2004 #2 You can use data>validation, allow>custom =AND(LEN(A1)<=5,EXACT(A1,UPPER(A1))) if you select A and do the above and use the above formula it will allow max 5 characters and they all have to be upper case -- Regards, Peo Sjoblom JINXY said: is there a fomula i can use that would make a cell case sensitive and Click to expand... would only allow a certain number of characters
You can use data>validation, allow>custom =AND(LEN(A1)<=5,EXACT(A1,UPPER(A1))) if you select A and do the above and use the above formula it will allow max 5 characters and they all have to be upper case -- Regards, Peo Sjoblom JINXY said: is there a fomula i can use that would make a cell case sensitive and Click to expand... would only allow a certain number of characters
