Excel annoyingly remembers the last setting for Text to Columns.

Pick some dummy data and run T to C with no delimiters to reset to neutral.

Then copy the different table.


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 06:04:02 -0700, eat more bacon
wrote:

I copied a table from Access into Excel and then took one of the columns,
which contains URLs and parsed it using the Text to Columns feature, so I
could easily separate the piece of the URL I needed. No problem there.

Now, however, I am copying a different table from Access into Excel. This
table is to remain as is. However, for some reason Excel is automatically
parsing this table when I paste it into Excel. This happens whether on the
same worksheet, a different one, or even if I try a different workbook. For
some reason, the 'text to column' feature seems to be automatically enabled,
even though i no longer want it.

I've never seen this behavior before and not sure how to end it.

Thanks,
Allan