Extracting a number out of a sentence

Hi I am looking for an equation or macro that can extract numbers out of a sentence.

Eg, 'There were 300 children in a school, and 10 classes of children' I need to extrcat the 300 and the 10 into 2 cells.

There may be more than 2 numbers in longer sentences. Is there anyway to do this?

Thanks in advance