Is there a function in Excel that will allow me to look at just the last two letters of a text string, and perform an operation based on what those letters are?

In other words, if I am in cell E12, I want to do something like this:

if [last_two_letters_C12]=ar,[append "áste" to the contents of E12],
if [last_two_letters_C12]=er,[append "íste" to the contents of E12],
if [last_two_letters_C12]=ir, [append "íste" to the contents of E12]

What I don't know how to do is parse out the last two letters of C12 to operate my if... statement.

Is there a simple way to do this? (Anybody who has had a year of high school español will know what I am trying to do here.) smile

tanstaafl.
_________________________
"There Ain't No Such Thing As A Free Lunch"