How to automatically replace the text in a cell if it contains a specific word?

Regular Contributor



Hello everyone!

In the above image, Which function can I use to replace the text in a cell that contains a specific word with another word. I have text of this kind "Yes: 05.03.2021 14:03"  (all the cells are different), and I need to replace it with just "Yes".


Please help..???

3 Replies
I found the solution.

Is it correct?
Used and tested AOK assuming your version of Excel uses the comma argument separator.
If in EU or Indonesia use: