Extract one numerical value from single cell with multiple values?

[cszy67]

I cut and paste data from another program into Excel and end up wit
rows of cells just like these (minus quotation marks):

B2="PARTS 1068 928 1007 626 850 732 600 468
380 6659"
B3="PARTS 205788 195118 189078 179515 169556 149411 148064
125511 112170 1474211"

All of the data above is contained in a single cell after I paste it i
- how can I extract the mathematical values and place them in individua
cells for future calculations?

Thanks in advance

 

[MrShorty]

Does Data->Text to columns (then work through the text wizard) do what
you want?

 

[cszy67]

MrShorty that was simply amazing!

Thanks a million - for as long as I have worked with Excel I never kne
that existed - it worked perfectly