Remove 3 words from Microsoft excel text cell.

Question

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.&nbsp;EgCurrent cell valueNeeded cell value3 unit of Cleaning soap 3LCleaning soap 3L3 packs of CIF dishwasherCIF dishwasher3 Cartons of 3M masks3M masks3 bags of Plaster of ParisPlaster of Paris&nbsp;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.&nbsp;Please help! Thanks in Advance for your support.&nbsp;

riny_van_eekelen · Accepted Answer

Pratichi&nbsp;This one will work:=RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1," ","|",3)))&nbsp;

Forum Discussion

Remove 3 words from Microsoft excel text cell.

2 Replies

Resources

Current cell value	Needed cell value
3 unit of Cleaning soap 3L	Cleaning soap 3L
3 packs of CIF dishwasher	CIF dishwasher
3 Cartons of 3M masks	3M masks
3 bags of Plaster of Paris	Plaster of Paris