Is the parsing only happening after you've run data|text to columns (or opening
a text file) in that excel session (it doesn't occur right after you open excel
and your workbook)???

I'm guessing that your earlier text to columns is causing the trouble.

Put something in an empty cell (like asdf)
then do the text to columns.
Choose delimited
but uncheck all the options
and finish up
Then clean up the cell.

Then try pasting your data.



meltemi wrote:

I think I'm using Excel 2007, but I'm not sure because they hid the "Help
About" menu. There's a question mark icon at the upper right that leads to
online help, but the online help regarding how to find the version number
refers to menu items that I don't see anywhere.

How do I turn off automatic parsing for pastes or file imports? It always
does the wrong thing and parses on tabs. As suggested all over the web,
before the paste or import I tried doing a "Text to Columns" with settings
that will would correctly for the data I'm trying to import, but the import
still gets mangled.

--

Dave Peterson