Thanks Ron. Exactly what I needed -- no pun intended.

"Ron Rosenfeld" wrote:

On Mon, 4 Feb 2008 13:47:01 -0800, Ed Cones
wrote:

Is there a function that'll tell me whether a single character in a cell is
upper or lower case? IsUpper() would be nice, but it ain't there ;)

Currently I'm just doing a case-sensitive sort to isolate them, but I'm
hoping for something quicker.

thx


=EXACT(A1,UPPER(A1))

will return true if the letter in A1 is uppercase; otherwise it will return
FALSE.
--ron