In one columns I have multiple variations. I need help with extracting numbers and decimal numbers after multiple criteria.
because there could be other numbers in the same cell the formula does not work. 
LOOKUP(9.9E+307,--LEFT(MID(K27,MIN(FIND({1,2,3,4,5,6,7,8,9,0}, $K27&"1023456789")),999),ROW(INDIRECT("1:999"))))
Nor does this 
=LOOKUP(10^8,--MID(N23,MIN(FIND({0,1,2,3,4,5,6,7,8,9},N23&"0123456789")),{1,2,3,4,5,6,7,8}))

Criteria
TRC
Rate is
RT
rate @

Example of what is in a cell:
ext 3333 at 12:00 on 23 July. Rate is 12.6677
I need 12.6677 extracted so I may use it for calculation.

I should be able to add to this as I get more examples.

Many thanks