I want to extract part of the cell content matching a specific pattern and put in another cell.
Example: “Find What is the size?=Small”, remove “What is the size?=” and put “Small” in the new cell. The problem is “Small” doesn’t follow a particular length, pattern or list. It could be “Medium”, “XL”, “Big” etc.
Also the pattern can be anywhere in the string, also in the end. So I cannot necessarily assume there will be a comma at the end.
Here is three sample rows:
What is the size?=Small, Style=Super chick, How often?=Every 14. day, Which day=Friday, How long?=2 months, Note to order=Hello, thanks for the order
Style=Super chick, Which day=Friday, How long?=2 months, Note to order=Hello, thanks for the order, How often?=Every 14. day, What is the size?=Small
Style=Super chick, Which day=Friday, Note to order=Hello, thanks for the order, What is the size?=Small, How long?=2 months, How often?=Every 14. day
What is the size?=Small, Note to order=Hello, thanks for the order