Text to Columns

  • Thread starter Thread starter MVP
  • Start date Start date
M

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.
 
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.
 
Back
Top