If( ) statement against Alpha character range

  • Thread starter Thread starter pablo
  • Start date Start date
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())
 
This works, but it's case sensitive
=IF(AND(CODE(I2)>CODE("A"),CODE(I2)<CODE("Z")), TRUE, FALSE)

Dan E
 
Back
Top