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!
<tbody>
Transaction
DKK Amount
<tbody>
400-2000-1001-653...