How do I turn off Text to Columns
 

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?

How do I turn off Text to Columns
 

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?

How do I turn off Text to Columns
 

Go to a cell and try to parse out the data again, but turn off the delimiters
that you chose the last time. That should fix it.

"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?