MID Function is Letter or Number

[MTSDavid]

Hello I am fairly new to formula in Excel

Is is possible to use the MID function to find out if say character 6 is a letter (A,B,C etc) or a numeral (1,2,3,4 etc)

in the example below the letter could be any of the 26 letters of the alphabet
and numbers could be any 0 - 9

12516VBRAKAK


1254516VBRAKAK

1ST line has 5 numbers then changes to Alphabet
2nd line as 7 numerals the chances to alphabet

thanks

 

[Legacy 143009]

=ISNUMBER(MID(A1,6,LEN(A1)))

Have a nice day

 

[FormR]

Hi, you can use this to determine if the 6th character is a number (TRUE) or not (FALSE).

=ISNUMBER(0+MID(A1,6,1))

 

[MTSDavid]

Hello

thanks for the reply, unfortunately it does not work, could this be because the cell contents are not seen as number?


David

 

[MTSDavid]

Hello

thanks for this suggestion, this does work, what does the 0+ actually do to the formula?

David

 

[FormR]

what does the 0+ actually do to the formula?

Hi, MID() will always return text so ISNUMBER() will always return FALSEE without some extra steps to convert the value it returns to a number. With Excel, if we perform a mathematical operation on text that looks like a number Excel will automatically convert it to a number - the "0+" step performs this operation.

 

[MTSDavid]

Thanks guys much appreciated.

David