B
benjamin.d.rogers
This is the behavior I observe in Excel that I would like to change:
Excel 2003
1) Paste from a delimited text file (comma, tab, space, doesn't matter)
into Excel (text appears in a single column)
2) Parse using Data > Text to Columns
3) Clear all from current worksheet
4) Paste from the same delimited text file into that same worksheet,
any other worksheet in the same workbook, or even any new workbook
opened in same instance of Excel
5) Text appears parsed, as if step 2 (Data > Text to Columns) was done
automatically.
If I paste from the delimited text file into a new instance of Excel,
this "auto-parse" does not happen. If I close the current instance,
then open same workbook again, this "auto-parse" does not happen.
The question: How to prevent auto-parse from happening while working
in the same instance of Excel?
Excel 2003
1) Paste from a delimited text file (comma, tab, space, doesn't matter)
into Excel (text appears in a single column)
2) Parse using Data > Text to Columns
3) Clear all from current worksheet
4) Paste from the same delimited text file into that same worksheet,
any other worksheet in the same workbook, or even any new workbook
opened in same instance of Excel
5) Text appears parsed, as if step 2 (Data > Text to Columns) was done
automatically.
If I paste from the delimited text file into a new instance of Excel,
this "auto-parse" does not happen. If I close the current instance,
then open same workbook again, this "auto-parse" does not happen.
The question: How to prevent auto-parse from happening while working
in the same instance of Excel?