Text to Columns

[MVP]

How does one turn off the automatic "text to columns" that occurs when you
previously parsed something with a delimiter? E.G. If you do a text to
columns on a comma separated string, the next time you paste a string in the
worksheet, it will automatically parse - even if you don't want it to.

 

[Dave Peterson]

You can close excel and restart it <yechh!>.

Or you can put some junk in an empty cell
data|text to columns|delimited
but remove all the delimiters
finish up
clean up that junk in that formerly empty cell.