How do I turn off Text to Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Do another Text to Columns operation, but this time, uncheck or remove the
delimiter that you specified the first time.
 
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.
 
Back
Top