Dividing Cells with list of numbers

I am trying to copy over a spreadsheet that has been put into a pdf. file. When I paste it into excel it pastes all of the columns into one so I have the correct number of rows but what was once in 22 columns is now in one so my cell looks something like this: 12 23.4 45 56.7 23.4 etc.

Is there a better way to paste this into excel without an issue or is there a way to divide the cell at every space or something along those lines?

-Thanks
Chad

Hi there,

Select column with data then go to Data > Text to Columns and choose delimited. Click space and it should seperate for you

The attached link will help

http://www.worldstart.com/tips/tips.php/1153

VBA Noob

Thanks again.

Again a fast and simple answer.


-Chad

No problem.

Thanks for the feedback

VBA Noob