Text-to-columns problem

I use a number of macros that I've set up which use the text-to-columns function regularly.

After using this (and also on its own, not necessarily within a macro) I find that if I try to copy/paste from an external application into Excel, the resulting paste comes in as CSV garbled info, for example splitting a number up into 2 seperate columns as if its still trying to text-to-column the info.

I'm wondering if there's an easy way to clear the clipboard or something as at the moment I have to keep rebooting to stop it thinking I want text-to-columned info.

Many thanks...