I have a massive amount of data in each cell. The USEFUL INFORMATION that I need is actually VERY SMALL. However, at the moment i have to read the whole cell to extract what i do need... and there are 100s of rows of this.

Is there a formula (or perhaps in my case, sets of formulas), that can clean out my text to what I am looking for?

I have attached an example of what I have, with what I need.

Column A is what I have, and there are SOME EXAMPLES in Column B of what the resulting text should look like

## Bookmarks