How do I stop automatic conversion of text-to-columns in excel?

When I've used copy and paste of text into a workbook followed by
Data-Text-to-columns once, excel seems to assume that every future paste of
text also requires a text-to column conversion even when I don't want that to
happen. How do I stop this occurring.

thanks

john bell

You can close and reopen excel (yech!)

Or you can put some dummy data into a cell
data|text to columns
delimited
uncheck all the options
and finish up.

Then clean up that dummy data in that cell.

wraith_oz wrote:
>
> When I've used copy and paste of text into a workbook followed by
> Data-Text-to-columns once, excel seems to assume that every future paste of
> text also requires a text-to column conversion even when I don't want that to
> happen. How do I stop this occurring.
>
> thanks
>
> john bell

--

Dave Peterson

Many thanks Dave. That behaviour has been really annoying me.

jb

"Dave Peterson" wrote:

> You can close and reopen excel (yech!)
>snip
>
> wraith_oz wrote:
> >
> > When I've used copy and paste of text into a workbook followed by
> > snip
> --
>
> Dave Peterson
>