Hello!

I'd like to know how to change the last character(s) (or add or delete a character) in each word, when there are 2 or more words in a cell. Of course, this change or replacement should be based on certain rules, such as (I apologize, but I'll have to write all the examples in my language):

if any words in a cell ends with "ev", it should be changed so that it ends with "evega" (for example natrijev > natrijevega)
if any words in a cell ends with "id", it should be changed so that it ends with "ida" (for example klorid > klorida)
if any words in a cell ends with "na", it should be changed so that it ends with "ne" (for example kislina > kisline)
and so on....
...


So if I have "natrijev klorid" written in a cell it should be changed to "natrijevega klorida" or "acetilsalicilna kislina" should be changed to "acetilsalicilne kisline" or "natrijev metamizolat monohidrat" should be changed to "natrijevega metamizolata monohidrata".

I think it would be easier using a formula, but I kinda do not know how to start.
So I would very much appreciate your help.


Regards