Formula to extract Figures from String

[cvpjk]

Im a complete beginner to excel so need help with this urgently.

I need to extract the DKK figure from the transaction cell to the DKK amount.

is there a formula which is most suitable?
Ive been doin this manually for 2 weeks!

Transaction​	DKK Amount
400-2000-1001-653 DKK29.76 <tbody> </tbody>	29.76

<tbody>
</tbody>

 

[Finalfight40]

maybe:

=RIGHT(A1, LEN(A1)-SEARCH("DKK", A1)-2)

 

[steve the fish]

There will be plenty of ways. Assuming your example typical of all ie the DKK is always at the end then:

=0+MID(A1,FIND("DKK",A1)+3,99)

 

[alansidman]

Assumes your data is in A1, then =MID(A1,FIND("DKK",A1)+3,5)