Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn Off Text To Columns
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn Off Text To Columns
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: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
Messy Text to Columns | Excel Discussion (Misc queries) | |||
Justify text across multiple columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions |