Split a sentence with numbers into different columns

[DRS2016]

Hi everyone. I am new on this forum. I need some help on spliting sentences with numbers into different columns. Sentences vary in length. I need a formula that I can drag down.
The sentences look something like this:

The user with id '77073' viewed the section number '19' of the course with id '8914'.

I want each word and number to be in a separate column


I know how to split text into different columns but it is obviously not working for the sentences with numbers.

[Glenn Kennedy]

You seem to have marked this as "solved", without any explanation or comment. So... Just it case it's not actually solved, here are three possible solutions based around this formula:

=TRIM(MID(SUBSTITUTE(" "&$A1," ",REPT(" ",125)),125*COLUMNS($A:A),125))

assumes data in a1, copied across as far as needed. This will return the numbers exactly as shown:L '77073'. I have also provided two variants, one which returns them as text that look like numbers i.e. 77073 or as real numbers that can be added, subtracted, etc. Take your pick...

[DRS2016]

Thanks Glenn- This is very helpful. I used text to columns option and somehow it worked (just trying different options). Thanks a lot for your help...