Hi - is there any formula that could detect the last two letters in a word and depending on what those letters are, substitue with other letters? They are Spanish words I'm working with. So, if the word in A1 was "hablar" and in A2 I wanted "hablas", I would use the LEFT expression to remove and replace the last two letters. This would be okay if all the words finished with the same two letters but some don't! Therefore in A3 I might have the word "abrir" and this needs to change in A4 to "abres". Would there be a formula to cover - if the word in A1 or A3 ends in "ar" replace with "as" or if it ends in "ir" replace with "es"? I'm not able to work this out at all so any help would be gratefully recieved!