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

Regular Contributor

Web capture_6-3-2021_03940_www.udemy.com.jpeg

 

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.
=LEFT(B2,FIND(":",B2)-1)

Is it correct?
Yes!
Used and tested AOK assuming your version of Excel uses the comma argument separator.
If in EU or Indonesia use:
=LEFT(A6;FIND(":";A6)-1)
HopeThisHelps