If( ) statement against Alpha character range

P

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())
 
D

Dan E

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

Dan E
 
Top