Ah. This solution would test if it's within the range of A~Z as well.
Useful. Thanks to you as well.

"Tyro" wrote:

If your single character is in A1 you could this to determine if the
character is upper case: =AND(CODE(A1)=CODE("A"),CODE(A1)<=CODE("Z"))
That returns TRUE if the character is upper case, FALSE if not. Or you could
adapt it to look at specific characters in a word by using the LEFT, RIGHT
or MID
functions.

Tyro

"Ed Cones" wrote in message
...
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