Control V settings
When I copy from the bar at the top of my excel screen and try pasting into
another cell, the words are split into adjacent individual cells. How do I change this setting back to normal please? |
Control V settings
Since you copied from the formula bar, you could paste into the formula bar.
But the problem is the result of a previous Data|Text to column. Excel likes to help by remembering the parms you used when you ran data|text to columns. One way around it is to close excel and reopen it (yech!). Another way is to select an unused cell put some dummy data in that cell data|text to columns delimited, but uncheck each option finish up that wizard clean up the cell. Vampiress wrote: When I copy from the bar at the top of my excel screen and try pasting into another cell, the words are split into adjacent individual cells. How do I change this setting back to normal please? -- Dave Peterson |
All times are GMT +1. The time now is 04:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com