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
mainrotorAsked:
Who is Participating?
 
Ejgil HedegaardCommented:
Select all data in column A.
On the Data tab, select Text to columns, and choose Space as the delimiter.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.