Hi all,

I'm missing something obvious here but I can't see it. In A2 I have HE123 (formatted as 'General'). I am trying to test if the 3rd character is a number. For some reason the formula I have written returns FALSE. 

=ISNUMBER(RIGHT(LEFT(A2,3),1))