Hi,
I am wanting a formula for this spreadsheet.
Column A has a list of descriptions for example "red pens pack of 100" or "red pens pk25"
What i am wanting is in column B to pick up Pack of 100 or pk25 (numbers would change).
Ive got partly there with this...