IF formula

[luisitocarrion1900]

I need formula to paste in column C that if Column B the number is not in this format BE0573C will return a false, for example if it don't start if two letters follow by 4 numbers and ending with a letter it should return a false

 

[mrshl9898]

Will it only ever be letters or numbers? Below will fail if a special character is in a text spot for instance.

=IF(AND(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},LEFT(B2,2)))=0,COUNT(FIND({0,1,2,3,4,5,6,7,8,9},MID(B2,3,4)))=4,COUNT(FIND({0,1,2,3,4,5,6,7,8,9},RIGHT(B2,1)))=0,LEN(B2)=7),"",FALSE)