View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Turn Off Text To Columns

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

--
Kind regards,

Niek Otten

"Rcih" wrote in message
...
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?