You can do this without a macro, if you'd prefer it. You can parse the
last two letters of an entry with the RIGHT() function. If the word
EXCEL is entered in cell A1, then
=RIGHT(A1,2) returns EL.

Add this to the formula you posted:
=a2&""&b2&RIGHT(A1,2)