Hi Guys

I have a problem when excel 'remembers' half of the text to columns
that I did before.

I paste a text file into column A. Then I text-to-columns it and
specify that some/all of the columns should be imported as TEXT rather
than general.

Then, when I paste the next text file excel cleverly remember where to
cut the file into the columns (as soon as I paste it, it automatically
does the text-to-columns), but it doesn't do the formatting as text as
I requested.

How on earth can I switch it off? Or get excel to stop automatically do
the text-to-columns. So far the only way out for me is to restart
excel.

Regards
CE Auke