Thread: HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Dunn Steve Dunn is offline
external usenet poster
  
Posts: 193
Default HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B
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.


"Rodrjua" wrote in message
...
I am trying to developt a formula that restrict symbol characters to be
entred as data, help me!

Reply With QuoteReply With Quote