Hi Everyone,
I have a long list of data with one column i need to break apart.
The column contains this for example
A1: “ApplesPack6”
A2: “SomeApplesx6pack”
A3: “ApplezSIXpack”
A4: “AppleBananaSixPack”
i want to break these cells apart into fruit and pack size columns by creating rules such as “IF cell contains “Apple” write “Apple” in B1”, or “IF cell contains “Apple” and “Banana” then write “Mix” in cell B1 etc.
I am working with thousands of lines, and would likely need 1000+ IF statements to do this (which is not ideal). Instead i want to put this into some kind of rules table so it is much easier to manage. The rules table in first column would have a variation likely found in the original file, such as “Applez” then the corresponding columns i want to associate with that file, such as “Apple”.
My question: How can i create a workflow, so that it looks at a cell in the original data, then scans my “rules table” to see if any part of the cell, even if has text connecting either side, contains that letter / number combination?
thank you in advance!!
