frnkt68
New member
- Joined
- Jul 31, 2014
- Messages
- 8
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 365
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):
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 write it correctly.
So I would very much appreciate your help.
Regards
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 write it correctly.
So I would very much appreciate your help.
Regards