Separate one cell into 11

[Vic]

How do I separate one cell containing "1041 305 15 3 0 6 37 0
0 2 14" into 11 cells each containing one number? Space indicates the
end of the number. I need to repeate this formula for every row.
Thanks.

 

[Luke M]

2 ideas:
1) Use data - text to columns, with a space as delimiter, then copy - pate
special - transpose, to get the data into rows

2) Use the following formula copied down until you get an error
=RIGHT(A1,LEN(A1)-FIND(" ",A1))