how to stop auto text to column

[rhythmrealty]

Using Excel 2007 and the damned program is now taking my paste and
automatically doing a text to columns. How do I stop it?

 

[Shane Devenshire]

If you copy data that looks like it is a delimited set of data Excel
sometimes does what I think you're describing. If you are copying a single
enter the solution is to select the target cell and then put you cursor on
the Formula Bar and paste.

 

[Dave Peterson]

Excel is trying to help.

Earlier you ran a text to columns (manually or in code) and it remembers the
settings you used.

To make excel forget your settings:
#1. You can close excel and reopen it (yechhh!)
#2. You can do a dummy text to columns.
pick an empty cell
type something into it
do the text to columns
Use delimited, but uncheck all the options
finish up that wizard
and clean up this cell's contents.

 

[T. Valko]

Depending on how much this bugs you (it bugs me a lot!), JWalk has a macro
you could assign to a toolbar button:

http://spreadsheetpage.com/index.php/tip/clearing_the_text_to_columns_parameters

You'd just have to remember to click the button after you've done a TTC
operation.

 

[Dave Peterson]

And if you have a macro that does this text to columns and you share it with
others, it's a good idea to include that kind of clean-up routine.

It may stop emails and phone calls!