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

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