Forum Discussion
How to automatically replace the text in a cell if it contains a specific word?
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"...
I found the solution.
=LEFT(B2,FIND(":",B2)-1)
Is it correct?
=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
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
- It works😊😊
Thank you so much sir..😊😊