Splitting Multiple Numbers in One Cell to Multiple Cells

I need help again. As per the simplified list attached. I need to quickly convert the list in column A into the list in column C. Come cells in column A only have one number, other cells will contain multiple numbers of which are separated by a space. The desired result is that I have a list which only lists all of the numbers but only one number per cell.

Thanks!

copy then paste special into ms word as unformatted text(ms word edit menu for paste special)
select all and use find replace
in find just put a single space with the space bar
in replace type "^p" (without quotes case sensitive)
click replace all
select all copy paste back to excel