Forum Discussion

Excel's avatar
Excel
Iron Contributor
Mar 05, 2021

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"  (all the cells are different), and I need to replace it with just "Yes".

 

Please help..???

excel

3 Replies

Sort By
  • Excel's avatar
    Excel
    Iron Contributor
    Mar 05, 2021
    I found the solution.
    =LEFT(B2,FIND(":",B2)-1)

    Is it correct?
    • Norman_Harker's avatar
      Norman_Harker
      Brass Contributor
      Mar 05, 2021
      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
      • Excel's avatar
        Excel
        Iron Contributor
        Mar 05, 2021
        It works😊😊
        Thank you so much sir..😊😊

Resources