If statement with "Left"

Originally Posted by Ace_XL

=NOT(ISNUMBER(MID(A1,8,1)*1))

...or you could save a function call and use this:

=ISERROR(MID(A1,8,1)+0)