Extract number from a string expression

Extract number from a string expression

Is there any way to extract a number from a string expresion to use it a numeric calculation

ie: string1 = "10 apples"; string 2 = "5 Oranges"

Formula ?

Resulting value the number 15

Regards Flemming

fl.l.jensen