software

I did the following:

1. copied data from a text file
2. pasted it into column A in EXCEL 2003
3. used DATA/TEXT TO COLUMNS to parse it into multiple columns

It all worked fine.

I then went to past additional data in and EXCEL immediately converted it
into multiple columns using the TEXT TO COLUMNS criteria. Nice feature, but
that is not what I wanted to do. How can I shut this off?

..csv files and .txt files behave differently. Rename them to the type that
meets your requirements.

--
Kind regards,

Niek Otten

quot;Rcihquot; gt; wrote in message
...
gt;I did the following:
gt;
gt; 1. copied data from a text file
gt; 2. pasted it into column A in EXCEL 2003
gt; 3. used DATA/TEXT TO COLUMNS to parse it into multiple columns
gt;
gt; It all worked fine.
gt;
gt; I then went to past additional data in and EXCEL immediately converted it
gt; into multiple columns using the TEXT TO COLUMNS criteria. Nice feature,
gt; but
gt; that is not what I wanted to do. How can I shut this off?
Excel likes to help by remembering the parms you used when you ran data|text to
columns.

One way around it is to close excel and reopen it (yech!).

Another way is to select an unused cell
put some dummy data in that cell
data|text to columns
delimited, but uncheck each option
finish up that wizard
clean up the cell.

Rcih wrote:
gt;
gt; I did the following:
gt;
gt; 1. copied data from a text file
gt; 2. pasted it into column A in EXCEL 2003
gt; 3. used DATA/TEXT TO COLUMNS to parse it into multiple columns
gt;
gt; It all worked fine.
gt;
gt; I then went to past additional data in and EXCEL immediately converted it
gt; into multiple columns using the TEXT TO COLUMNS criteria. Nice feature, but
gt; that is not what I wanted to do. How can I shut this off?

--

Dave Peterson