SOLVED

Remove 3 words from Microsoft excel text cell.

Copper Contributor

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 valueNeeded cell value
3 unit of Cleaning soap 3LCleaning soap 3L
3 packs of CIF dishwasherCIF dishwasher
3 Cartons of 3M masks3M masks
3 bags of Plaster of ParisPlaster of Paris

 

I tried searching online but most solutions are related to removing characters or removing 1st and last word in a text string or remove everything before or after a particular word (like "of", as in the last example, if I clear everything before "of" it result in the last eg come as "Paris" instead of "Plaster of Paris"). I haven't been able to find a solution on how I remove just the first 3 words.

 

Please help! Thanks in Advance for your support. 

2 Replies
best response confirmed by Pratichi (Copper Contributor)
Solution

@Pratichi This one will work:

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

Screenshot 2021-08-17 at 05.29.02.png 

amazing works perfectly thanks @Riny_van_Eekelen
1 best response

Accepted Solutions
best response confirmed by Pratichi (Copper Contributor)
Solution

@Pratichi This one will work:

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

Screenshot 2021-08-17 at 05.29.02.png 

View solution in original post