<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have an excel spreadsheet that contains 1 column. &nbsp;Each row in that column has multiple values separated by blank spaces. &nbsp;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? &nbsp; <br />
<br />
Here is what a value in one of the rows in column A looks like:<br />
<br />
COLUMN A<br />
AccountField1 &nbsp; 47 &nbsp;FALSE &nbsp;TEXT &nbsp; TESTACCT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
<br />
I want the data to display like this:<br />
<br />
COLUMN A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COLUMN B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COLUMN C &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COLUMN D &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COLUMN E<br />
AccountField1 &nbsp; 47 &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FALSE &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TEXT &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TESTACCT &nbsp; <br />
<br />
<br />
How can I do this?<br />
<br />
Thanks in advance,<br />
mrotor
</div>
</div>


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

I need help parsing data in EXCEL 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.