Re: Data Validation - Again!
- From: "mlv" <mike.safetycatchvincent@xxxxxxxxx>
- Date: Tue, 22 Apr 2008 17:46:14 +0100
Dave Peterson wrote:
Just to add to Martin's response:
The =upper() function isn't required. If you're doing a simple
text comparison, excel will return true for:
If you really only want uppercase X's, you could use =exact():
I was falling back on my AutoLisp programming knowledge when I wrote the
formula and I wanted to make sure that both an uppercase 'X' and a lowercase
'x' would be accepted.
In AutoLisp the comparison is case sensitive, so it is necessary to convert
the text to a known case and compare like for like:
(= "x" "X") would return nil (False), whilst
(= (strcase "x") "X") would return T (True)
It didn't occur to me that Excel might not need the text case conversion.
Thanks for the information.
-Please remove 'safetycatch' from email address before firing off your
- Prev by Date: Re: Data Validation - Again!
- Next by Date: Suppressing Alert messages on open
- Previous by thread: Re: Data Validation - Again!
- Next by thread: Re: Data Validation - Again!