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!

[TABLE="width: 500"]
<tbody>[TR]
[TD]

Transaction​

[/TD]
[TD="align: center"]DKK Amount[/TD]
[/TR]
[TR]
[TD][TABLE="width: 216"]
<tbody>[TR]
[TD="width: 216"]400-2000-1001-653 DKK29.76[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD] 29.76[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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)