ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do i stop paste from spreading text across multiple cells ? (https://www.excelbanter.com/excel-programming/293180-re-how-do-i-stop-paste-spreading-text-across-multiple-cells.html)

Niek Otten

How do i stop paste from spreading text across multiple cells ?
 
It's probably not spread across cells, but just displayed across cells.
Enter a space in the cell next to the one you paste in.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Chris W." wrote in message
...
Using Excel 2000:
Is there anyway to stop Excel's Paste method from taking multiline data

thats been put onto the clipboard and spreading it across multiple cells. I
need to copy large chunks of text and graphics and paste into distinct cells
for later retrieval.




All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com