Do another Text to Columns operation, but this time, uncheck or remove the
delimiter that you specified the first time.



--
Hope that helps.

Vergel Adriano


"Blulak7" wrote:

I've used text to columns with a delimiter to import some text into excel.
The problem is that now I can't turn it off. Every time I past data it wants
to apply text to columns to the pasted data. Also it does not format the
text to columns the same way that I initially set it up. Any idea?