Extracting two separate numbers from one cell

[Dennis Foldager]

Hi all

I would really appreciate your help on a little issue I have not been able to solve despite extensive google'ing

I have the below text in one column (each line has its own cell/row) and I would like to extract the digits following "SKU" to one column and the digits before "æsker" to the next column. It would be great if it could be done with a formula so I can easily add to my list later on.

SKU10013.IT – 103 æsker
SKU11841.IT – 32 æsker
SKU10031.IT – 64 æsker
SKU11025.IT – 16 æsker
SKU11035.IT – 16 æsker
SKU10021.IT – 80 æsker

Two notes:
1) First number can vary between 5-6 digits
2) Second number can vary between 1-3 digits


I have found plenty of suggestions on how to do this for one number but none for extracting two separate numbers so really hope someone here can help.

Thanks a lot