SOLVED

Remove 3 words from Microsoft excel text cell.

%3CLINGO-SUB%20id%3D%22lingo-sub-2654522%22%20slang%3D%22en-US%22%3ERemove%203%20words%20from%20Microsoft%20excel%20text%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2654522%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3CBR%20%2F%3EI'm%20an%20average%20excel%20user%20and%20would%20like%20to%20know%20if%20there%20is%20a%20way%20to%20remove%20the%201st%203%20words%20from%20a%20text%20string%20in%20excel.%26nbsp%3B%3CBR%20%2F%3EEg%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%20height%3D%2229px%22%3ECurrent%20cell%20value%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%20height%3D%2229px%22%3ENeeded%20cell%20value%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2229px%22%3E3%20unit%20of%20Cleaning%20soap%203L%3C%2FTD%3E%3CTD%20height%3D%2229px%22%3ECleaning%20soap%203L%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%20height%3D%2229px%22%3E3%20packs%20of%20CIF%20dishwasher%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%20height%3D%2229px%22%3ECIF%20dishwasher%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%20height%3D%2229px%22%3E3%20Cartons%20of%203M%20masks%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%20height%3D%2229px%22%3E3M%20masks%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%20bags%20of%20Plaster%20of%20Paris%3C%2FTD%3E%3CTD%3EPlaster%20of%20Paris%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20searching%20online%20but%20most%20solutions%20are%20related%20to%20removing%20characters%20or%20removing%201st%20and%20last%20word%20in%20a%20text%20string%20or%20remove%20everything%20before%20or%20after%20a%20particular%20word%20(like%20%22of%22%2C%20as%20in%20the%20last%20example%2C%20if%20I%20clear%20everything%20before%20%22of%22%20it%20result%20in%20the%20last%20eg%20come%20as%20%22Paris%22%20instead%20of%20%22Plaster%20of%20Paris%22).%20I%20haven't%20been%20able%20to%20find%20a%20solution%20on%20how%20I%20remove%20just%20the%20first%203%20words.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!%20Thanks%20in%20Advance%20for%20your%20support.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2654522%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2654575%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%203%20words%20from%20Microsoft%20excel%20text%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2654575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1129969%22%20target%3D%22_blank%22%3E%40Pratichi%3C%2FA%3E%26nbsp%3BThis%20one%20will%20work%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DRIGHT(A1%2CLEN(A1)-FIND(%22%7C%22%2CSUBSTITUTE(A1%2C%22%20%22%2C%22%7C%22%2C3)))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-17%20at%2005.29.02.png%22%20style%3D%22width%3A%20540px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303650i5D3B88780189BAB3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-17%20at%2005.29.02.png%22%20alt%3D%22Screenshot%202021-08-17%20at%2005.29.02.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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