Extract numbers from alphanumeric

Hello All,

I have a requirement to extract numbers from alphanumeric.
Below are the few possible scenarios:

Residential 1st Charge - Maximum 30%
Debt <£30m - Maximum 4.0x
Vessels over 55 Years - Maximum 45%
Tenants - Minimum 1.05x
Schools - Maximum 60%
Overdraft - Maximum 2 Year
Maximum 1 Year
Maximum 10 Years


From the above, I have to extract the numbers (with decimals) after text ("Minimum" or "Maximum") i.e. 30, 4.0, 45, 1.05, 60, 2, 1, 10 and ignore other numbers which comes before i.e. 1, 30 & 15.

Thanks in advance.

Originally Posted by AlKey

Enter in B1 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B
1	Residential 1st Charge - Maximum 30%	30
2	Debt <£30m - Maximum 4.0x	4
3	Vessels over 55 Years - Maximum 45%	45
4	Tenants - Minimum 1.05x	1.05
5	Schools - Maximum 60%	60
6	Overdraft - Maximum 2 Year
7	Maximum 1 Year
8	Maximum 10 Years

Is there a way to modify this formula to replace "Year" & "Years" with spaces, so it can work for other scenarios?
Thanks in advance.