R Rodrjua Apr 29, 2010 #1 I am trying to developt a formula that restrict symbol characters to be entred as data, help me!
S Steve Dunn Apr 29, 2010 #2 This will limit data entry to alphanumeric characters: =SUMPRODUCT((MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1)>="A")*(MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1)<="Z")+ISNUMBER(-MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1)))=LEN(A1) Are there any other characters which you may wish to enter? Steve D.
This will limit data entry to alphanumeric characters: =SUMPRODUCT((MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1)>="A")*(MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1)<="Z")+ISNUMBER(-MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1)))=LEN(A1) Are there any other characters which you may wish to enter? Steve D.
