Extracting two separate numbers from one cell

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

Please post a small sample workbook. I have tried to recreate your sample, but I suspect that the characters on your software are different from mine and a standard =find is failing. It would be helpful to see actual data in a spreadsheet.

I have found these two formulas to work:

Formula:

Please Login or Register  to view this content.

and

Formula:

Please Login or Register  to view this content.

I don't have the long dash on my keyboard so I've used the Character code to find.

*Hadn't seen your sample file when replying. The above work on my pc with the values copied from your first post, however, they fail with the sample.

DBY