I have something I dont thing is difficult but still I dont know how to do it

When copyng and pasting info from acrobat I recieve the info in a single
cell, I want to paste it in different cells depending on the spaces:

in cells(1,1) is writen

Profit 7% 9% 15% 12% '(all toghether)

and I want this

cells(1,1) cells(1,2) cells(1,3) cells(1,4) cells(1,5)
Profit 7% 9% 15% 12%

TIA