Formula for string of 9 characters to see if 8th character is odd or even

Hello
i have a problem i am building a database and i need a formula to put in colum F if the reference string which always have 9 characters(numbers and letters) if the 8th character is an odd number then allow it to be inserted into the cell if it is an even number then say this is the wrong but do not allow it to be inserted i also need same formula that works the oppsite way around allowing 8 number to be inserted if even but not odd
I havnt got a working model of this Hope you can help thanks

Steve

Hi, if your filed in A1 cell, try this formula:

Please Login or Register  to view this content.

Maybe something like this.

Please Login or Register  to view this content.

Or you could use Data Validation with this formula for the Custom option

=AND(LEN(F2)=9,MOD(MID(F2,8,1),2)=0)

you can then add an Input Message and an Error Alert to alert the user as to what is needed, etc

This returns true and false great now i need a formula to say if true then message box "correct if false wrong please

Cutter that is returning an error mate

Are you referring to the initial "The formula currently evaluates to an error. Do you wish to continue?" error?
If so then click on Yes. It initially errors because it's blank.