My suggestion would be to use the FIND and MID functions. Then you can slowly piece together the formula by building segments or portions of the formula, then combining the segments together and then simplifying it.

First, I would use the FIND formula to find the word "is" in the text.

=FIND("is", A1)

That's going to give you a result of 17. That means that the character "i" in the first instance "is" was the 17th character. That makes the first number of 0.15% the 20th character.

So the formula for the first character of that number would be:

=FIND("is", A1) + 3

To find the last character of it, you can use the same find formula to find the % symbol.

=FIND("%", A1)

Note that I'm leaving the start number out. This assumes a start number of 1. This formula will give a result of 24.

When we subtract our start position from our end position we have to add 1 to it to get the correct number of characters for the length of the string.

For example:

24 - 20 = 4, so we have to add 1 to get 5 characters

24 - 20 +1 = 5, giving us the correct length

We then can start combining these formulas into the MID formula which returns the text that we want.

=MID(A1,FIND("is",A1)+3,(FIND("%",A1)-(FIND("is",A1)+3)+1))

You can do pretty much the same process to find the second number. But for the second number you will want to add a start number to find the second iteration of "is".

=FIND("is", A1, FIND("is", A1) + 1)

Basically what we are telling Excel is to find the 2nd instance of the word "is" in the string. We state that the starting point is 1 more character than the first instance of the first word "is".

You then can use the previous processes to figure out how to get the rest of the formula.