Aug 16 2021 08:08 PM
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 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 |
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.
Aug 16 2021 08:30 PM
SolutionAug 16 2021 08:36 PM
Aug 16 2021 08:30 PM
Solution