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.

MVP wrote:

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.
--
mvp

--

Dave Peterson