If( ) statement against Alpha character range

[pablo]

Is it possible to do an IF() against a range of alpha
characters A to Z? Would I have to convert the bottom and
top characters to an ASCII value?

Here is what I am thinking about:

=IF(AND(I2>"A",I2<"Z"),
VLOOKUP(),
VLOOKUP())

 

[Dan E]

This works, but it's case sensitive
=IF(AND(CODE(I2)>CODE("A"),CODE(I2)<CODE("Z")), TRUE, FALSE)

Dan E