Extract Several Numbers From Text String

Hi.

I'm a bit rusty with parsing out text and hope that someone has a forumla for me to use. Here's a few examples:

M RTG 1525; MY HGR-P-T 100042; RPT 100721 (this is in one cell) I need each number in a different cell
M RTG 1525; MY ROV/HPP/HGG 100042; RPT 100721 (this is in one cell) I need each number in a different cell
R HRX 36180; 174021 (this is in one cell) I need each number in a different cell
M RTG 1526 (Testing data) Copied to my version ROV/HPP/HGG 100248 and RPT 101505 (this is in one cell) I need each number in a different cell

There is no consistency to the madness.

THANKS!

What are you classing as a 'number' here? In the top row, do you just want '1525', '100042' and '100721'?

I need anything that looks like a whole number in a different cell. I should've gave examples of how it should be:

Column A
M RTG 1525; MY HGR-P-T 100042; RPT 100721


Column B 1525

Column C 100042

Column D 100721

Fantastic:0

How about this example

M RTG 1526 (Testing data) Copied to my version ROV/HPP/HGG 100248 and RPT 101505

same need as the others

Can you add two Substitute functions like and If statement?