Formula/Macro help need for pulling "words" from a cell
Hello,
I've attached a file, one worksheet containing my "raw data" and the other containing the "finished workbook". I've been working with this data and manipulating it by hand, through sorting and deleting. I'm wondering if anyone can help me come up with a macro or formula that will do the work for me.
Making a macro for this is way over my head, and need suggestions and tips on how to extract the data from the text in each cell. I've tried first, last and mid formulas, but I'm just a novice on excel and don't know where to begin to pull the specific "words" that are shown in the "final example" worksheet. I guess I wouldn't be really extract "words" so much as the such and such "word" in the string?
Thank you so much, any advise, help, ideas would be greatly appreciated!
Note - In the finished example worksheet, the numbers in column A are strictly there for my sorting purposes and don't need to be included in any macro or formula.
If you can come up with a set of rules how to distinguish wanted from unwanted data, I'm sure it would be fairly simple. From what I see, though, the data looks unpredictable.