Hi, I have a tricky problem to solve:
I need to calculate a blended interest rate (like APR) that gets one value from a text string.

The column looks like this:
Completion £799,
Arrangement £499,
Arrangement 1.50% Advance,
Arrangement £499,
Arrangement £499,
Arrangement £499,
Completion 1.25% Advance (Min £300.00),
Arrangement £799,
Arrangement £799,
Arrangement 1.50% Advance,
Arrangement 2.00% Advance (Min £599.00),

To work out the rate I may need to create two new columns, one containing £ and the other % values.
I then use an IF statement in the blended rate cell to select the value.
Any ideas?