Simple importing question with XL07

[NPK]

When I attempt to import this data sheet from the host webpage, it will sort by rows, but it will only fill in one column. I cannot find an option for space deliminated in 2007 and don't really know if this exists.

This data will need to be updated from the web each time the workbook is opened, then the data internally will be used in ohter sheets within the workbook

Thanks in advance.

 

[NPK]

Too easy...

Data - Text To Cells - Deliminated - Space