Prev: Which (logical) function?
Next: adding time in a work schedule
From: Rodrjua on 28 Apr 2010 19:31
I am trying to developt a formula that restrict symbol characters to be
entred as data, help me!
From: Steve Dunn on 29 Apr 2010 05:12
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" <Rodrjua(a)discussions.microsoft.com> wrote in message
news:61E5CBBC-B00E-4BCF-B46D-8A9B5D247836(a)microsoft.com...
>I am trying to developt a formula that restrict symbol characters to be
> entred as data, help me!

 | 
Pages: 1
Prev: Which (logical) function?
Next: adding time in a work schedule