Hi Everyone,

I'm trying to extract some text from a long data dump in cell A2 in a spreadsheet. The difficulty I'm having is I have only one consistent point. From the screenshot shows a sample of the string
  1. Point number 1 shows the text "Changed Status", which is the only consistent point.
  2. I want to extract the text highlighted in Yellow
  3. The carriage return at the end of the line above the Yellow highlight text is the other point, but that's not consistent position.

So, creating the formula to find the first occurence of "Changed Status" (marked number 1 in the image) is the easy bit, but I'd like to extract the text between Changed Status and the carriage return (marked number 2 in the image) that precedes it.

Is that possible?

Any help you can give will be much appreciated.

Excel Extract.png