Replace 3 Characters from Right in String

[barim]

Hello,

I tried to find an example online, but no luck.

I have a huge list of strings that some of them end with "ini" as a suffix. I would like to replace it with "not". The trick here is that the length of words is variable, it can go from 3 until 15 and more. Not all words have such suffix, I need to find it first and replace it regardless of the words' length.

Thank in advance.

 

[Norie]

Perhaps.

=IF(RIGHT(A1,3) ="ini", LEFT(A1,LEN(A1)-3)&"not", A1)