[SOLVED]Order Code has 1 letter added need function to delete said letter

I have an order code that has a letter at the end i need to clear

JUN123456A

to make

JUN123456

=MID(B5,SEARCH("JUN",B5,1)+0,9)

That works perfect, but I come across

MAY123456A

So I need to have function to do both MAY and JUN

=MID(B5,SEARCH("JUN""MAY",B5,1)+0,9)

I guessed this, doesnt work.

Suggestions

Just use this:

=LEFT(B5,LEN(B5)-1)