Hi,
To describe the situation, in column A I have a reference, 1,2,3.... in column B I have a long string of raw data, there are several thousands of rows. The data is very unstructured but within some of the cells is information I am looking for. Usually it looks something like "gibberish (Name) gibberish" and I am looking for the name in the middle (not always same position but always somewhere in middle of the cell)
So I want to create column C that will list all of the values, be it the actual instances where it found the phrase (Name) or the reference number I created in column A. Notice that it needs to be specific "(Name)" as Name without brackets pops up all of the time as well and I don't need that, but I think matching exact won't work because of the gibberish around it (which is always different).
I can do this quite easily using filters, but I do this over and over again at work and I want to automate this process or at least know how to do similar things better in the future.
I'd love to upload it but 1. The files are very large, 2. they're secured 3. they're confidential.
Please help!
To describe the situation, in column A I have a reference, 1,2,3.... in column B I have a long string of raw data, there are several thousands of rows. The data is very unstructured but within some of the cells is information I am looking for. Usually it looks something like "gibberish (Name) gibberish" and I am looking for the name in the middle (not always same position but always somewhere in middle of the cell)
So I want to create column C that will list all of the values, be it the actual instances where it found the phrase (Name) or the reference number I created in column A. Notice that it needs to be specific "(Name)" as Name without brackets pops up all of the time as well and I don't need that, but I think matching exact won't work because of the gibberish around it (which is always different).
I can do this quite easily using filters, but I do this over and over again at work and I want to automate this process or at least know how to do similar things better in the future.
I'd love to upload it but 1. The files are very large, 2. they're secured 3. they're confidential.
Please help!