<div>
how do i react to the menu--&gt; submenu
</div>


<div>
You can use Text to Columns to separate data after you copied to 1 column.<br />
<br />
Curt
</div>


You can use Text to Columns to separate data after you copied to 1 column.

Curt

<div>
On Step 1 of the wizard, choose &quot;Delimited&quot;, On Step 2 select &quot;Comma&quot; and then on Step 3 just click the Finish button.
</div>


On Step 1 of the wizard, choose "Delimited", On Step 2 select "Comma" and then on Step 3 just click the Finish button.

<div>
...this of course, I'm just &quot;guessing&quot; because I didn't saw a sample file/data from you.
</div>


...this of course, I'm just "guessing" because I didn't saw a sample file/data from you.

<div>
Sorry jppinto, my screen was empty when I posted.<br />
<br />
Curt
</div>


Sorry jppinto, my screen was empty when I posted.

Curt

<div>
jppinto: Choose delimited but select (input) &lt;space&gt; character as the delimiter??? etc
</div>


jppinto: Choose delimited but select (input) <space> character as the delimiter??? etc

<div>
<div class="content wysiwyg-content">
I have excel 7 loaded.<br />
<br />
When i copy/paste space delimited data into excel, instead of data appearing in different columns, all data appears on the same column in excel<br />
<br />
How do i tweak excel to put all space delimited data on different columns.<br />

</div>
</div>


I have excel 7 loaded.

When i copy/paste space delimited data into excel, instead of data appearing in different columns, all data appears on the same column in excel

How do i tweak excel to put all space delimited data on different columns.


place space delimited data on to different columns of excel

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 Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.