I need help parsing data in EXCEL 2007

Hi Experts,
I have an excel spreadsheet that contains 1 column.  Each row in that column has multiple values separated by blank spaces.  Is there a way to parse the data in each row based on the blank spaces, so that the values are put in their own separate column?  

Here is what a value in one of the rows in column A looks like:

COLUMN A
AccountField1   47  FALSE  TEXT   TESTACCT              

I want the data to display like this:

COLUMN A        COLUMN B      COLUMN C      COLUMN D      COLUMN E
AccountField1   47                       FALSE              TEXT               TESTACCT  


How can I do this?

Thanks in advance,
mrotor