Forum Discussion

Pratichi's avatar
Pratichi
Copper Contributor
Aug 17, 2021
Solved

Remove 3 words from Microsoft excel text cell.

Hi All, I'm an average excel user and would like to know if there is a way to remove the 1st 3 words from a text string in excel.  Eg Current cell value Needed cell value 3 unit of Cleaning...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Aug 17, 2021

    Pratichi This one will work:

    =RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1," ","|",3)))

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 17, 2021

Pratichi This one will work:

=RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1," ","|",3)))

 

Resources