I was given an excel file where someone stored all of the information in a single column (var1). I need to pull information but it will be in random orders. Good thing is the person gave the information and then put a period after it.    Example of Var1: Type = 2. Size = 4 in x 12 in. Group = ABC grouping.   Group = A and B Holdings. Type = 1.    Group = Mark H and Company.    The variable I need to pull is group. It always starts with "Group = " and has a period in the end. But will be anywhere within the var1 (so you can't name a specific period. Sometimes it may not exist. This variable can be any length in words. I just need to pull the string between "Group = " and the period.    This can't be done in excel due to the size of the dataset.   I have tried scan, find, splitting at the period, and I am not sure what to do at this point to organize it.   ... View more