software

I am frequently using the text to column function. However when I do this
and then Paste new sets of data into excel it performs the text to column on
all of my data using the delimiter that I had previously set.

It does this if I do it in a different worksheet or a new excel file.
The only work around is to completely close down excel, reopen excel and
start from there.

Is there a better way to prevent the text to column function from performing
on my pasted text?

You can do a Data / text to Columns with no delimiters and it won't happen,
but agreed it's a pain.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;ASA_Joyquot; gt; wrote in message
...
gt;I am frequently using the text to column function. However when I do this
gt; and then Paste new sets of data into excel it performs the text to column
gt; on
gt; all of my data using the delimiter that I had previously set.
gt;
gt; It does this if I do it in a different worksheet or a new excel file.
gt; The only work around is to completely close down excel, reopen excel and
gt; start from there.
gt;
gt; Is there a better way to prevent the text to column function from
gt; performing
gt; on my pasted text?