Seperating text in a single cell

[cfuoss]

Hey guys I've converted a pdf file to excel and now there are some formatting issues. One of the biggest on is that the data i want to use is in a single cell. Here's an example:

"1 Car Rental/Gas 0.00 0.00 421.43 36.01 0.00 0.00 0.00 457.44 Yes No"

All of this is contained in one cell and I was wondering is there any way to split the data into multiple cells.

Thanks

 

[jmthompson]

Select the cell, data- text to columns, space as delimiter