problem with find formula

[nur2544]

Dear all , I am having a vary big sentence like (** ** means its also having other sentence )
********* with consolidated sep of dd. 0.92
here what ever the value after the “ sep of dd. “ need to copy . so here only 0.92
again its different way
********* with consolidated sep of dd. 22.45
here what ever the value after the “ sep of dd. “ need to copy . so here only 22.45

it is something like this!! but the problem is that last value is changeable

IF(ISNUMBER(SEARCH("sep of dd.",A1)),RIGHT(A1,6))