To find occurrence of a particular word and replace with a completely different word

[obebewele]

Please, how do I replace the occurrence of a particular word in a table row and replace with a completely different word?

Thanks in advance

[binuacs]

@obebewele The Find and Replace tool is an option for your use case

[obebewele]

Thank you sir Binuacs,

But I have gone through all the examples of Find an Replace, I can only replace when there is a matching word.

For my case, I want to replace all occurrences of the word "CNF" with the word "EXEC"

Thanks 

[binuacs · Accepted solution]

@obebewele in that case use the Replace() function in the formula tool

[obebewele]

Oh wow!

It worked perfectly!

Thanks.

I'm grateful!