Turn Off automatic parsing of data in Excel

[rcl2884]

I use Excel 2003

If I open up excel and then paste in a column of text, it gets pasted
in literally as text.

I then use the "Text to Column" feature to parse the data. All this
is fine.

However, the next time I paste in a column of text, Excel will
automatically parse the data as I paste it in. Does anyone know how to
turn this off? It seems to be an attribute the is preserved for the
current excel session. If I close out of excel and reopen it, then the
automatic parsing is not enabled. I want to be able to turn of the
automatic parsing within an excel session.

Thanks!

 

[AB]

Try this:
select any nonblank cell and do a fake data parcing - go through the
same steps just when you need to check/uncheck the parcing delimiter
(coma, semicolon, tab or whatever) uncheck those boxes > Finish.
Next time you paste the parcing won't be in effect.