RaunLGoode
Registered User.
- Local time
- Yesterday, 22:09
- Joined
- Feb 18, 2004
- Messages
- 122
I have run across this a couple of times recently. I am copying a value from a single cell in a table generated in SQL or in another worksheet. When I paste the value to the destination cell, the value separates to multiple cells. Like I had selected "Text to Column" and used the "space delimited" option.
Once the work book starts acting this way I can't get it to go back to the normal mode. If I close and re-open the sheet or re-start Excel it doesn't help. If I open a new spread sheet copy / paste works normally in the new sheet, but the problem remains on the old workbook. What am I doing to put Excel into this mode? More importantly, how do I reverse it?
Once the work book starts acting this way I can't get it to go back to the normal mode. If I close and re-open the sheet or re-start Excel it doesn't help. If I open a new spread sheet copy / paste works normally in the new sheet, but the problem remains on the old workbook. What am I doing to put Excel into this mode? More importantly, how do I reverse it?
