Excel data validation to exclude lowercase characters 1

[dgillz]

Is there a way to use data validation to exclude the possibility of inputting lower case character? Excel 2003. Any help appreciated.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[GlennUK]

You could use a nasty Custom validation formula:

=AND(MAX(CODE(MID(C1,ROW(OFFSET($1:$1,0,0,LEN(C1),1)),1)))<=90,MAX(CODE(MID(C1,ROW(OFFSET($1:$1,0,0,LEN(C1),1)),1)))>=65)

replacing C1 with whatever the active cell ref is when you set the Data Validation.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[GlennUK]

Actually, thinking about it, this is much a simpler Custom validation formula:

=EXACT(C1,UPPER(C1))

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

Glenn,

What beauty: Simplicity!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

Thanks Skip. :-D

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[dgillz]

Glen,

Please explain that second formula. I used it on the following 3 cell values and they all returned FALSE:

3/31/2010
Don
4/44/2010

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

Correction, the returned valued were

TRUE
FALSE
TRUE

The TRUE on the last value is problematic.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

Please ignore my last 2 posts, I am getting my threads mixed up before I have had coffee this morning.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html